LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 683
Default Unable to ftp workbook with excel 2002

The code below to save an excel workbook to an ftp site works for excel 2003
but does not work in excel 2002.
Is there a way to get it to work for excel 2002?

Sub test()
ActiveWorkbook.SaveAs
", FileFormat:=xlNormal
End Sub

get this message when running code in excel 2002.
Runtime error 1004
Method SaveAs of object _Workbook failed

Thanks
--
Brian
 
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
2002: Unable to delete Normal_xyz style inherited from workbook(xy Martti Pekkanen Excel Discussion (Misc queries) 1 November 5th 07 08:15 AM
Excel 2002 : Unable to open files in MS Outlook 2002 Mr. Low Excel Discussion (Misc queries) 1 June 29th 07 02:12 PM
Excel 2002 opens without showing a workbook Jen Excel Discussion (Misc queries) 2 February 22nd 07 04:43 PM
Unable to open excel workbook..... Tegan Excel Discussion (Misc queries) 2 February 14th 07 04:47 PM
"Unable to read file." Excel 2002 APT SA Setting up and Configuration of Excel 3 January 26th 05 09:39 PM


All times are GMT +1. The time now is 07:33 AM.

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

About Us

"It's about Microsoft Excel"