Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Programmatically saving a workbook to a ftp location fails
Hello
My company recently migrated from Excel 97 to Excel 2002. We are using an Excel spreadsheets, with a macro created to save a workbook to a ftp location. It worked fine on Excel 97. Now that we moved to Excel 2002, we receive the following error message when we run the macro: Run-time error '1004': Method 'SaveAs' of object '_Worksheet' failed Below is the code we're using: ActiveWorkbook.SaveAs FileName:= _ "ftp://duip501/usr/appl/sld/prod/data/ready/in/sld_bloomb_div_info.txt", _ FileFormat:=xlText, CreateBackup:=False MsgBox "The FTP has been completed. Please exit Excel and click on No when asked if file should be saved." Does anyone know why this code works in Excel 97, but not in Excel 2002? Your help is greatly appreciated. Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
problem saving workbook to network location | Excel Discussion (Misc queries) | |||
Sheets select method fails when workbook is opened by another workbook | Excel Programming | |||
Close Workbook Programmatically | Excel Programming | |||
saving excel file as tab delimited text programmatically | Excel Programming | |||
SaveAs method fails when saving to FTP site. | Excel Programming |