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