FTP Macro

[groovygarden]

I need to write a macro that does the following

*Saves an excel spreadsheet
*Saves a specific sheet or sheets as a web page and FTPs this to the right location on the webserver.

The idea is that people in my department who work on spreadsheets which we publish on the web can easily upload their work without having to get too involved in the process.

Its the FTP bit of the macro I'm stuck on... Is it even possible?! Will I have problems with permissions?

Any help is appreciated...

Thanks

 

[iSeriesCodePoet]

You can create an FTP script that can automatically FTP the file. Look at the FTP help on how to do this. Mike Wills
AS400 Programmer


Please, if you find my post useful, let me know.