Save as Web Page

  • Thread starter Thread starter Paul
  • Start date Start date
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?
 
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)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Saving Excel 2010 files as web page or single file web page 1
Saving as dynamic web page in Excel 2007 1
Save Excel 2007 as Web Page - no interactivity? 2
Add interactivity switch when save as web page 2
How to make URL link to sheet in Excel web page ??? 1
How to make url link to sheet in Excel web page ??? 4
Excel 2003 save as .XLSX 10
Page Setup when saving a worksheet as a web page 3

Back
Top