objWorkbook.SaveAs "M:\Test\Test.csv"
By the way, you might want to specify the file format when saving.objWorkbook.SaveAs "M:\Test\Test.csv", 6
ASKER
objExcel.ActiveWorkbook.Close False
Set objExcel = CreateObject("Excel.Application")
Set objWorkbook = objExcel.Workbooks.Open("M:\Test\Test.csv")
objExcel.Application.Visible = True
objExcel.Application.Run "PERSONAL.XLSB!Macro1"
objExcel.DisplayAlerts = False
objExcel.ActiveWorkbook.Close True
objExcel.Application.Quit
WScript.Quit
~bp
ASKER
ASKER
ASKER
Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.
TRUSTED BY
\\SERVER\SHARE\FOLDER\
Than try run macro again