export all worksheets as html

  • Thread starter Thread starter Ronio
  • Start date Start date
R

Ronio

I was able to use Ron DeBruin's excellent macro to take a master sheet and
break it into seperate sheets based on a value in the first column.

Now I need a macro that will save every worksheet to HTML with the 'add
interactivity' box checked.

Can somebody point me to an existing macro?

TIA,
Ron
 
Nevermind, some days I'm just not thinking clearly.

I embedded the "ActiveWorkbook.PublishObjects" inside of DeBruin's original
macro.
So it saves the worksheet as html after populating it.
 

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

Macro not copying (or pasting?) content of all cells 3
Office 2007 Excel Macro to save Active Worksheet to HTML by name 1
Run macro on all files in a specific folder 3
How to change this Ron deBruin Macro 10
Macro for all Excel Workbooks to print to PDF 2
Macro to combine worksheets 10
merge worksheets 3
Email selected sheets 5

Back
Top