Export from spreadsheet to HTML using a macro

Export from spreadsheet to HTML using a macro

Post by n.kennedy9 » Sat, 16 May 2009 20:51:35


Hi all

I have a few files set up, and have set up sheets within the files to
export to HTML using the File -> Save As Web Page menu command.

When I set these up, I used the full file path (not a drive letter) as
others also need to be able to export the HTML files. However, I can
run the files, save and have the exports produced, no one else can.

Is it possible, therefore, to have the export written within a macro
so all will be able to export properly.

Cheers muchly in advance

Neil