Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
ActiveWorkbook.SaveAs
I have transfered from Office 2005 to 2007 Excel Macros which have now
stopped working on the "ActiveWorkbook.SaveAs" line. I have started getting the infamous "Error 1004." The whole line is highligted, which leads me to believe that the start of the line is the problem. I include the line as in Macro, with the exception that the "My Documents" on to the underscore would be on one line: ActiveWorkbook.SaveAs Filename:="C:\Documents and Settings\Frank\My Documents\transfer\ftproot\aartfile.xls", _ FileFormat:=xlExcel9795, Password:="", WriteResPassword:="", _ ReadOnlyRecommended:=False, CreateBackup:=False Any help will be deeply appreciated. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ActiveWorkbook.SaveAs Returns | Excel Programming | |||
ActiveWorkbook.SaveAs problem | Excel Programming | |||
'ActiveWorkbook.SaveAs Filename' | Excel Programming | |||
ActiveWorkbook.SaveAs Problem | Excel Programming | |||
activeworkbook.saveas | Excel Programming |