Lazy Technology. To all MacroMakers.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

haripoter - 30 Oct 2004 18:55 GMT

Good Day! My name is Kitch and I'm a Macro Enthusiast. ;)

My subject is called Lazy Technology. Due to I'm lazy of using
different keyboard shortcuts. And I'm taking advantage of the
technology to perform this task for me by just one click of a
button.

I would like to share some of my macros but I also need some of
your macros. I don't have much knowledge about VBA that is why
I'm looking for a very useful but not very complicated macros. :D

==============================================

Here are some of my macros.

COMBINED COMMANDS = RECOMMENDED NAME

SelectAll+Copy = Copy All
= Copy entire characters in the document/s.

SelectAll+Cut = Cut All
= Cut entire characters in the document/s.

SelectAll+Delete = Delete All
= Delete entire characters in the document/s.

==============================================

In this thread, I would be considering already that you knew how
to make simple macros. Thank You.

"Knowledge is dangerous." - kitchp

Please reply if:
1) you want my full detailed instructions;
2) you want to give comments or suggestions;
3) you want to know what is the use of my macros;
4) you find it useful;
5) you have time.

"Knowledge is dangerous." - haripote

--
Message posted from http://www.ExcelForum.com

Reply to this Message

Jezebel - 31 Oct 2004 06:42 GMT

Don't give up your day job.

> Good Day! My name is Kitch and I'm a Macro Enthusiast. ;)
>
[quoted text clipped - 40 lines]
> ---
> Message posted from http://www.ExcelForum.com/

Reply to this Message

Malcolm Smith - 31 Oct 2004 07:51 GMT

A lot of these are simple keystrokes.

I can't see what is simpler than Control-a then Control-c, for example.
That's only a couple of finger movements:

Little finger on Control key.
Middle finger on a then release
Index finger on c
release all

I can do this with one fluid movement.

You mentioned that you don't know VBA but surely to select and copy all
the text on all the documents would require some sort of VBA? So if you
had fifteen documents open then how would you copy all the characters to
the clipboard?

I'm sorry, but I don't understand what you're driving at here.

- Malc

Reply to this Message

RWN - 02 Nov 2004 02:51 GMT

That's where I've been going wrong!!
I've been using my thumb on the Control key.

Signature

Regards;
Rob
------------------------------------------------------------------------

> A lot of these are simple keystrokes.
>
[quoted text clipped - 16 lines]
>
> - Malc

Reply to this Message

haripoter - 03 Nov 2004 10:50 GMT

Hi thank you very much for all your replies and comments...

Its just that I used to make macros without touching or even going t
Visual Basic Editor.

Tool --> Macros --> Visual Basic Editor Alt+F11

I used to combined keyboard shortcuts into one command.

It's like what do we usually do next when we use [Select All o
Ctrl+A]?

We usually use [Copy or Ctrl+C] and the rest.... right?

What if we combine [Select All] and [Copy], and assigned it to
keyboard shorcut or convert it by just "Single click of a button."

Using "Record new macro...." will help...

Tool --> Macros --> Record new macro...

I find these "time saving" on my part... where I usually work as
Document Analyst.... and I used to code 60,000 characters per day wit
99.95-100% quality rating where some of the documents ar
repetitious....

I just want to share this to all of you... it will help you work mor
faster and efficient...

Like what I said "I'm looking for a very useful but not ver
complicated macros"

thank you very muc

--
Message posted from http://www.ExcelForum.com

Reply to this Message

Jezebel - 05 Nov 2004 02:54 GMT

> Its just that I used to make macros without touching or even going to
> Visual Basic Editor.

Yes, well that's the first part of your problem. If you looked at the code
after creating your macros using the recorder, you'd see just how dreadful a
way this is to create macros: large amounts of redundant code, exclusive
reliance on the Selection object, and wild assumptions about the state of
Word and your document at the time the macro is called.

> I just want to share this to all of you... it will help you work more
> faster and efficient...

On the contrary. Nothing you've suggested here will do that.

> Like what I said "I'm looking for a very useful but not very
> complicated macros"

Using the macro recorder for anything but trivial, quick-and-dirty purposes
gives exactly the opposite -- complicated code that is not very useful.

Reply to this Message

Malcolm Smith - 05 Nov 2004 10:24 GMT

> Yes, well that's the first part of your problem. If you looked at the
> code
[quoted text clipped - 4 lines]
> of
> Word and your document at the time the macro is called.

Indeed, in fact is there a check that there is a document there at all if
the Selection object is used?

I agree 100% with what you have written here. Using the macro recorder
for production code is not a very good idea at all.

- Malc

Reply to this Message