Export from spreadsheet to HTML using macro

[n.kennedy927]

Hi all

I posted this a couple of days ago, just thought I'd jump it back to
the top of the pile

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, it
is to a shared drive but we have all mapped differently) 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

 

[nick]

Yes, you should be able to use the full path, not the drive letter.

so... replace:
d:\MyFile.htm
with
\\ServerName\MyFile.htm

Right click on a file in explorer, and choose properties to get the
full path.