Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Word XP - speedy code execution...

Status
Not open for further replies.

slwolf8

Technical User
Apr 23, 2001
82
US
I am trying to make the code in my macro as efficient as possible so that my macro will not take as long to run. Are there any general VBA guidelines for Word that you can suggest?

A general overview of my macro is that the user inputs information into a userform and when completed, the user presses the "Finish" button. The code checks to see if all the required questions have been answered (it does this by checking for a text value of ""), places the user input at bookmarked locations in a Word doc, prints the document to a networked printer and then brings up an Outlook email that has a body which consists of the text that is in the document.
 
1) Application.ScreenUpdating = False
2) Intensive use of With ... End With

Hope This Help, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top