Lazy Technology. To all MacroMakers.

H

haripoter

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
 
M

Malcolm Smith

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
 
H

haripoter

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
 
J

Jezebel

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.
 
M

Malcolm Smith

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.


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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top