Paste to Find in Macro

[Dennis Doll]

I was trying to create a macro to find text previously
copied to the clipboard. When I recorded the macro, I
pasted the text into the Find dialog box, but the macro
only recorded the specific text, not the paste function.

Anybody know how to force it to paste from the clipboard.

Thanks,

Dennis

 

[Doug Robbins - Word MVP]

Hi Dennis,

See the article "Manipulating the clipboard using VBA

How to clear the clipboard or get the text on the clipboard into a string
variable" at:

http://www.mvps.org/word/FAQs/MacrosVBA/ManipulateClipboard.htm

Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP

 

[E. Omar Troccoli K.]

Hi,

I made a custom template for my job with a lot of macros. The final size of
the template is about 150 KB. The template is working well and make the
appropiate tasks fine. The template is the basic document for my office,
and the people work in it and send me her work via e-mail, always. But I
noted than many files have the .dot atributes (or extension) and the size
is the same than the original template: when you run it, you see the final
documents with all the macro inside the document, and too others documents
that have the .doc extension, the size of the file es about 25 kb and no
have macros at all.

I wonder why it happens and the way for generate always a .doc file without
the macros, all the time. There is a big diference for us dowloading a lot
of big document with macros (without utilitily after generate the document)
and a simple and "light" .doc document without any macro at all.

Then, I need a code or any sugestion that help me to eliminate all the
macros in the
document generated with my template.

Any helps will apreciate. Thanks in advance and... forgive my english,
please,


Omar
From Argentina

 

[Word Heretic]

G'day "E. Omar Troccoli K." <[email protected]>,

sounds like people are explicitly opening the template and doing a
save as .doc and using copies of that doc to generate new document
instances.

Hi,

I made a custom template for my job with a lot of macros. The final size of
the template is about 150 KB. The template is working well and make the
appropiate tasks fine. The template is the basic document for my office,
and the people work in it and send me her work via e-mail, always. But I
noted than many files have the .dot atributes (or extension) and the size
is the same than the original template: when you run it, you see the final
documents with all the macro inside the document, and too others documents
that have the .doc extension, the size of the file es about 25 kb and no
have macros at all.

I wonder why it happens and the way for generate always a .doc file without
the macros, all the time. There is a big diference for us dowloading a lot
of big document with macros (without utilitily after generate the document)
and a simple and "light" .doc document without any macro at all.

Then, I need a code or any sugestion that help me to eliminate all the
macros in the
document generated with my template.

Any helps will apreciate. Thanks in advance and... forgive my english,
please,


Omar
From Argentina

Steve Hudson

Word Heretic, Sydney, Australia
Tricky stuff with Word or words for you.
Email (e-mail address removed)
Products http://www.geocities.com/word_heretic/products.html

Replies offlist may require payment.