Macro to export each sheet as separate Webpage

02-22-2017, 03:15 AM

mogilshik

Junior Contributor

Join Date: Aug 2003

Location: Saint-Petersburg

Posts: 369

Macro to export each sheet as separate Webpage

Hello!
I wonder if you can help me create a macro which will export each worksheet (50 of these) as a separate webpage? The save as webpage allows to save the whole workbook but the sub pages look clumsy and do not have all the styles embedded in them (For separate publication throughout the website)
Thanking you gladly!)
Dima

Attached Files

Files(1).zip (6.8 KB, 6 views)

__________________
Look past them as though there's something there which is distracting you. When they turn around to see what it is, hit them on the head with an esky lid. Pretend it fell from a tree, even if there are no trees around
"...21 Fun Things To Do Or Say When Your Being Yelled At.."

02-22-2017, 11:24 AM

Cerian Knight

Macro to export each sheet as separate Webpage

Polymath (in disciplina)

Super Moderator
* Expert *

Join Date: May 2004

Location: Michigan

Posts: 4,206

Since Excel 2007, when you select 'Save As' 'Web Page', you have the option to Publish the 'Entire Workbook' or 'Selection: {current selection}' (which could be a single sheet).

If you publish only the selected sheet, do you still have issues with the styles?

If that works, you only need modify a recorded macro to automate the file name change from the default (Book1.htm) to the sheet name, etc.

__________________
I got all the answers wrong on the GLAT, apparently even #9 (where I put a period in the middle of the box and labeled it 'singularity ripe for rapid inflation').