Hi Carter,
The below link will help to you.
Export data to an existing xls
else
common Macro to export excel for 6 different objects
Using below macro code u can create the folder in dynamically and saved the file,
vPath = Ur path folder i.e D:\\Test\
strDate = Year(Date()) &"-"& month(date()) &"-"& Day(Date())
set vPathName = ActiveDocument.Variables("vPath")
GetVarValue = vPathName.GetContent.String
Dim filesys
Dim newfolder
set filesys=CreateObject("Scripting.FileSystemObject")
If Not filesys.FolderExists(GetVarValue) Then
Set newfolder = filesys.CreateFolder(GetVarValue)
filePath = newfolder&"\Test_"&strDate&".xlsx"
Else
filePath = GetVarValue&"\Test_"&strDate&".xlsx"
End If
objExcelDoc.SaveAs filePath
