• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 563
  • 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?
1 Solution
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)
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

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