PDA

View Full Version : FTP an Excel File



microwonder
08-20-2008, 11:32 AM
Hello,

I am trying to create a macro that will save a spreadsheet to a specified FTP, but I am unsure how to go about creating this macro. Any help would be greatly appreciated.

Thanks,
Microwonder

TomSchreiner
08-20-2008, 02:50 PM
Hi MW.

Is there any reason that you need to create a macro? Simply enter the address in the save or saveas dialog. This path saves to my ftp.

ftp://tstom:MyPassword@home.fuse.net/Book1.xls

microwonder
08-21-2008, 10:38 AM
Because my supervisor asked for a macro :)

If you know of a way to create one that would be great. Anybody?

TomSchreiner
08-21-2008, 10:44 AM
Follow my instructions above with the macro recorder turned on...