Changing file directory from a temp folder

dwirony · #1 12-13-2016, 10:15 AM

Hello all,

I am having trouble getting my macro to save my document into the desired location. The program I use attempts to save documents to a default temporary folder, and even after recording the process it still won't save my document to my desired location. Am I doing something wrong? How can I get my macro to override the default location for documents?

Code:

Sub Savetolocation
'
'
ChangeFileOpenDirectory "C:\Users\dwirony\My Documents\Overflow Folder\"
    ActiveDocument.SaveAs2 FileName:=ActiveDocument.Fullname, FileFormat:= _
        wdFormatXMLDocument, LockComments:=False, Password:="", AddToRecentFiles _
        :=True, WritePassword:="", ReadOnlyRecommended:=False, EmbedTrueTypeFonts _
        :=False, SaveNativePictureFormat:=False, SaveFormsData:=False, _
        SaveAsAOCELetter:=False, CompatibilityMode:=14
End Sub

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Word 2010 Macro to rename Folder in Directory	staicumihai	Word VBA	2	10-28-2016 03:01 AM
vba code for folder name, subfolder directory, file name & revision times	klpw	Excel Programming	2	12-24-2015 12:31 AM
Command button - save in temp folder and send email with attachment	bigbird69	Word VBA	13	11-18-2012 10:06 PM
outlook 2003 always not remove temp copy of opened attachments in temporary folder	c.itech	Outlook	0	06-20-2011 10:34 PM
Error 451 - Could´t Open Temp file	greenberet	Outlook	1	09-06-2010 05:35 AM