We help IT Professionals succeed at work.
Get Started

Access VBA SaveAs does not work on Office 2013 of WOrd

557 Views
Last Modified: 2016-02-10
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?
Comment
Watch Question
This problem has been solved!
Unlock 1 Answer and 4 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE