Save a workbook to an FTP site?

Morning,

At work we have been using vba within excel to save documents to a central FTP site for years. Lately we been having trouble getting the file to save to the FTP successfully.

We are getting a message when we click on the upload button on the workbook saying "Runtime Error 1004 Method SaveAs of object _workbook failed"?

It seems to work ok on some computers especially those running Excel 2007 but on Excel 2002/2003 we have started to get this error message?

Any ideas?

Many thanks
Martyn


vba code:

Please Login or Register  to view this content.