asked on

Access VBA SaveAs does not work on Office 2013 of WOrd

From Access, when I have created a Word Document using VBA to open the document and populate it with data (using Bookmarks), I then usually save that document in a specific location with specific name, using the following VBA code:

objWord.ActiveDocument.SaveAs strSave

Where strSave is a string designating the location, like: "C:\Database\Documents\20003.docx". This has been working for years in different databases I have built from Access 2003 to 2010. Now, if I use that VBA code with Word 2013, it no longer works. It simply opens the Save As box and invites me to save the document in its original folder with its existing name, so I then have to manually select the new folder and new name.

I have searched Google for answers, but no luck. Can anyone tell me how to write the VBA code in the Office 2013 environment that will do the same as SaveAs does in the Office 2010 environment?

Norie

Have you tried specifying the file format?

NeilIrving

ASKER

Hi Norie. Thanks for responding.

No - According to a Microsoft article I read, if you don't specify the format, it will simply default to the current format. Did I get that wrong? If so, do you have a reference on how to specify the format?

ASKER CERTIFIED SOLUTION

NeilIrving

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Martin Liss

This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.