I've got a web client who wants daily postings of excel files that indicate project status to his website.
He has a seperate excel file for each client/project.
Has anyone else tried writing a macro that will take an excel file, reformat things like fonts and sizes, Save As web page and upload the file to an ftp site?
I think I can write the excel macro to reformat the sheet like I want and I know how to ftp the file to my site.
What i'm wondering is, what would be the best way to automate the entire process so every night my employer's excel sheets (about a dozen open projects at a time) all get resaved as web pages, and each uploaded to a unique ftp directory?
Any ideas?
He has a seperate excel file for each client/project.
Has anyone else tried writing a macro that will take an excel file, reformat things like fonts and sizes, Save As web page and upload the file to an ftp site?
I think I can write the excel macro to reformat the sheet like I want and I know how to ftp the file to my site.
What i'm wondering is, what would be the best way to automate the entire process so every night my employer's excel sheets (about a dozen open projects at a time) all get resaved as web pages, and each uploaded to a unique ftp directory?
Any ideas?
