Save as Web Page

P

Paul

Each time I save my workbook as an Excel workbook, I need
to Save As a Web Page, so that the information is
available on the company intranet. Is there a way I can
automate this, so that instead of clicking Save, then
clicking Save As Web Page, and navigating to the web
folder, then closing the web page version, and re-opening
the excel version to continue my work, can I run a macro,
or something a bit less cumbersome?
 
D

Dave Peterson

Couldn't you record a macro when you do it once manually.

Then just replay that macro when you need to do it again (and again and again).

File|SaveAs|webpage
followed by
file|SaveAs|normal workbook
(And since you do the normal workbook last, it'll still be a .xls file)
 
Top