Solved

VBA using MS Word 2013 will not save Document

Posted on 2014-04-07
7
1,789 Views
Last Modified: 2014-04-12
I am using the following statement to save the MS Word 2013 document after I updated a value in a bookmark.  This is being done with VBA

If ActiveDocument.Saved = False Then ActiveDocument.Save

A Save As dialogue box pops open rather than saving the document, when I click on the Save button in the dialogue box the Save As dialogue box pops open again and the document is not saved.

The code works correctly on the development machine but not on the machine I want the code to run on.  Both machine are running Office 2013 and Windows 7.  The problem is not a permissions problem, I changed the permissions to allow everyone to do everything just to check.
0
Comment
Question by:c7c4c7
  • 3
  • 3
7 Comments
 
LVL 35

Expert Comment

by:Bembi
ID: 39984519
You may check the optional argumetns of the save method. As long as you do not define the arguments, the save methods works with the default settings.
0
 
LVL 14

Expert Comment

by:DrTribos
ID: 39984687
I ran into a similar strangeness in Excel... it was, if you will the reverse problem, I had to save for a change to take effect.

Is it the case that prior to saving the only change to the document is the update to the bookmark?  If so, can I suggest making some other changes with VBA like adding some blank space at the end of a paragraph then trying the save.
0
 

Author Comment

by:c7c4c7
ID: 39984975
I made changes to the document using VBA other than the bookmark and it still doesn't work.

What I don't get is why it works on one machine and not another it's like there is some unique reference that needs to be added, but everything seems to have migrated correctly.

The one thing I see that is different is that the developing machine has reference to something called a Template Project that did not make it over when I copied the .docm to the new machine
0
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 
LVL 14

Expert Comment

by:DrTribos
ID: 39984976
The only other thing I can suggest is a corrupt user profile, can you try on the impacted machine under a new profile that you create from scratch?
0
 

Accepted Solution

by:
c7c4c7 earned 0 total points
ID: 39985009
Solved my own problem
In the IDE for VBA under Tools -> Reference the reference to the TemplateProject was marked as missing.  I unchecked it and a miracle occurred, the SaveAs box no longer appeared.
0
 
LVL 14

Expert Comment

by:DrTribos
ID: 39985018
How random - thanks for the follow-up
0
 

Author Closing Comment

by:c7c4c7
ID: 39995875
It worked
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

When creating Microsoft Word-based forms there may be a need to have a form field repeated throughout the whole document. For instance, with a company name, you may want this information repeated automatically throughout the document rather than man…
Shortcuts in Word Just the other day I had a training for Microsoft and they wanted me to show how well the new Windows and Office behaved on a touch device, which by the way is great, but it was only then that I realized that using keyboard shortc…
This video walks the viewer through the process of creating envelopes and labels, with multiple names and addresses. Navigate to the “Start Mail Merge” button in the Mailings tab: Follow the step-by-step process until asked to find the address doc…
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 …

920 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

14 Experts available now in Live!

Get 1:1 Help Now