but in the informal testing I've done, I've found that Visible = False makes Word work roughly 15% faster than Screen Updating = False does on identical tasks.That's about 1 second for every 7-not a trivial amount if your job runs longer than that. Chief among them is that repagination routines don't work when Word is invisible.Ed Disabling the screen in Access is the same as in Excel. Instead of using a macro, link your button to a subroutine and execute the queries from there.Ed Sorry, looks like it's as simple as Application. Here is a clip from a good help page by Tony D'Ambra.Article contributed by Daryl Lucas Many people know they can speed execution of Word Automation by turning off screen updating: Word. Screen Updating = False Many do not know, however, that they can get an even greater speed boost by hiding the application altogether.
My macro is updating the field codes of the documents. What method (action) are you using to execute your queries in the macro? I use the following Macro Options: Action: Open Query View: Datasheet Data Mode: Edit I would like to have each query saved with a different query name, so that I can modify them easily.So, I prefer Open Query action rather than Run SQL action.You can verify this by launching Word the old-fashioned way and opening File1 at the bottom of the File menu after running the sample code.Although it would be difficult to do an exhaustive test, in theory this should work from any Automation client-Visual Basic, Excel, Power Point, or any other.
[/size][/font] Try the following steps and let me know what happens: If it does not do the trick in a macro setting, I will show you how to accomplish it with just a few lines of VBA code. Before running your macro, make sure that the checkbox for confirming action queries is unchecked. Modify your macro to sandwich the Open Query action between the Set Warnings On = No and Set Warnings On = Yes actions as shown.