Firstly may apologise that this thread is in here as apose to the Excel group. THere does not seem to be alot of activity in there and it does not specify VBA questions allowed.
Within XP & 2K versions of Excel, I have a peice of code setup that allows you to publish a sheet that contains graphs to a web format.
What I would like to do is be prompted to specify the filename for the proposed html document and then alow the code to carry on doing the rest of the work.
So the user will click on a single button, be prompted for a filename, press OK and all the rest will be automatic, format, etc etc
Anybody got any ideas?
Toni
Within XP & 2K versions of Excel, I have a peice of code setup that allows you to publish a sheet that contains graphs to a web format.
What I would like to do is be prompted to specify the filename for the proposed html document and then alow the code to carry on doing the rest of the work.
So the user will click on a single button, be prompted for a filename, press OK and all the rest will be automatic, format, etc etc
Anybody got any ideas?
Toni