Solved

MS Word background save in VBA

Posted on 2013-06-16
6
709 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
  • 2
  • 2
  • 2
6 Comments
 
LVL 15

Expert Comment

by:weinberk
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
The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

 
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:weinberk
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

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

Question has a verified solution.

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

Microsoft Office Picture Manager was included in Office 2003, 2007, and 2010, but not in Office 2013. Users had hopes that it would be in Office 2016/Office 365, but it is not. Fortunately, the same zero-cost technique that works to install it with …
No matter the version of Windows you are using, you may have some problems with Windows Search running too slow or possibly not running at all. Before jumping into how you can solve this issue, just know there are many other viable alternative deskt…
Learn how to create and modify your own paragraph styles in Microsoft Word. This can be helpful when wanting to make consistently referenced styles throughout a document or template.
In a previous video Micro Tutorial here at Experts Exchange (http://www.experts-exchange.com/videos/1358/How-to-get-a-free-trial-of-Office-365-with-the-Office-2016-desktop-applications.html), I explained how to get a free, one-month trial of Office …

786 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