Export from spreadsheet to HTML using macro

  • Thread starter Thread starter n.kennedy927
  • Start date Start date
N

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
 
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.
 
Back
Top