Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old December 21st 04, 02:49 PM
Lloyd
 
Posts: n/a
Default Macro in Excel 2002 to save a workbook to a FTP location

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro not working with Excel 2003 Fernando Gomez Excel Discussion (Misc queries) 1 December 16th 04 12:19 AM
Stubborn toolbars in Excel 007 Excel Discussion (Misc queries) 9 December 11th 04 02:02 PM
Excel crashing on save as Roundy Excel Discussion (Misc queries) 1 December 10th 04 10:45 PM
Lotus 123 save as excel workbook and maintain formatting? Don Excel Discussion (Misc queries) 0 December 8th 04 12:15 AM
Lotus 123 save as excel workbook and maintain formatting? Don Excel Discussion (Misc queries) 0 December 8th 04 12:11 AM


All times are GMT +1. The time now is 06:14 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017