Creating Word document from Access

Posted on 2012-08-11
Last Modified: 2012-08-15
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?
Question by:jbotts
    1 Comment
    LVL 76

    Accepted 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)

    Featured Post

    Enabling OSINT in Activity Based Intelligence

    Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

    Join & Write a Comment

    Microsoft Word is a program we have all encountered at some point, but very few of us have dug deep into its full scope of features, let alone customized it to suit our needs. Luckily making the ribbon (aka toolbar, first introduced in Word 2007) wo…
    A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
    What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
    With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

    755 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    20 Experts available now in Live!

    Get 1:1 Help Now