Solved

MS Word background save in VBA

Posted on 2013-06-16
6
721 Views
Last Modified: 2013-06-22
Is there a way to execute a background save in MS Word 2003 via VBA?
ActiveDocument.Save  and ActiveDocument.SaveAs will save the document but the user has to wait until the save is complete unlike clicking on the save icon which allows the user to edit the document while the save executes (background save is turned on). In fact, VBA execution pauses while the save completes. Even code before the ActiveDocument.Save command pauses execution while the save completes. Is there a way to avoid this?
0
Comment
Question by:thenelson
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
  • 2
6 Comments
 
LVL 15

Expert Comment

by:Berkson Wein
ID: 39253399
The problem is that the Save process executes in the same thread.  I >>believe<< that the SaveAs (Or SaveAs2) is asynchronous so that should return immediately.  Are you sure that SaveAs doesn't work either?
0
 
LVL 48

Accepted Solution

by:
PortletPaul earned 500 total points
ID: 39254973
Save and SaveAs both work in the foreground, and SaveAs would also require making a copy (plus a target name and location)

Personally I don't believe you can invoke the 'background save' via VBA - I did some hunting yesterday and found nothing to suggest you can access the inbuilt background save.
Maybe it exists (perhaps by some undocumented hook?) but could not find it.
0
 
LVL 39

Author Comment

by:thenelson
ID: 39255027
For some reason my response to weinberk did not get saved.

Save and SaveAs both change the mouse cursor to an hourglass for a few seconds and editing is paused during that time. SaveAs2 allows editing almost immediately but the file modified time does not change and when I close the document immediately after running SaveAs Word asks if I want to save the document so I don't think it is doing anything.

I did discover a solution to the problem "Even code before the ActiveDocument.Save command pauses execution while the save completes." by placing a DoEvents just before the Save command.

PortletPaul,
Yes, I too spent some time searching for a solution before posting the question. I am hoping someone knows about some undocumented something.
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 48

Expert Comment

by:PortletPaul
ID: 39255040
:) given it's Word 2003 that's plenty of time for undocumented stuff to emerge.
Whilst I do not claim vast knowledge in this area, nor that my searches were exhaustive, I wouldn't be betting on finding this elusive feature. (but then I don't bet much anyway.)

good luck - I'll watch on to see if some gold nugget does arrive. Cheers, Paul
0
 
LVL 39

Author Comment

by:thenelson
ID: 39266896
I've requested that this question be deleted for the following reason:

There was no answer
0
 
LVL 15

Expert Comment

by:Berkson Wein
ID: 39266897
There was an answer, and I don't think this should be closed.  PortletPaul wrote: "Personally I don't believe you can invoke the 'background save' via VBA"
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

As with any other System Center product, the installation for the Authoring Tool can be quite a pain sometimes. This article serves to help you avoid making these mistakes and hopefully save you a ton of time on troubleshooting :)  Step 1: Make sur…
In this article we discuss how to recover the missing Outlook 2011 for Mac data like Emails and Contacts manually.
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
Learn how to make your own table of contents in Microsoft Word using paragraph styles and the automatic table of contents tool. We'll be using the paragraph styles in Word’s Home toolbar to help you create a table of contents. Type out your initial …

733 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