• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 560
  • Last Modified:

Creating Word document from Access

I have written code in Access to create a Word document. I am interested in speeding up the execution of the attached file, the subroutine used to create the document. Will creating functions use less memory and time but more processing time; or will it speed the creation of the document? Are there other ways to speed the execution of the subroutine?
PatientSummary.txt
0
jbotts
Asked:
jbotts
1 Solution
 
GrahamSkanRetiredCommented:
This looks like a tweak to a recorded macro. This necessarily uses the Selection object and tends to set all the default settings.

If I were to give you one piece of advice it would to be use Range object(s) instead of the Selection object, removing all unnecessary settings (because they are the default or are don't care)
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now