Macro to export each sheet as separate Webpage
Macro to export each sheet as separate Webpage
Macro to export each sheet as separate Webpage
Macro to export each sheet as separate Webpage
Macro to export each sheet as separate Webpage
Macro to export each sheet as separate Webpage Macro to export each sheet as separate Webpage Macro to export each sheet as separate Webpage Macro to export each sheet as separate Webpage Macro to export each sheet as separate Webpage Macro to export each sheet as separate Webpage Macro to export each sheet as separate Webpage Macro to export each sheet as separate Webpage
Macro to export each sheet as separate Webpage Macro to export each sheet as separate Webpage
Macro to export each sheet as separate Webpage
Go Back  Xtreme Visual Basic Talk > > > > Macro to export each sheet as separate Webpage


Reply
 
Thread Tools Display Modes
  #1  
Old 02-22-2017, 04:15 AM
mogilshik's Avatar
mogilshik mogilshik is offline
Junior Contributor
 
Join Date: Aug 2003
Location: Saint-Petersburg
Posts: 366
Default 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
File Type: zip Files(1).zip (6.8 KB, 5 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.."
Reply With Quote
  #2  
Old 02-22-2017, 12:24 PM
Cerian Knight's Avatar
Cerian KnightMacro to export each sheet as separate Webpage Cerian Knight is offline
Polymath (in disciplina)

Super Moderator
* Expert *
 
Join Date: May 2004
Location: Michigan
Posts: 4,193
Default

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').
Reply With Quote
Reply

Tags
export, macro, save, separate, webpage, sheet


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Forum Jump

Advertisement:





Free Publications
The ASP.NET 2.0 Anthology
101 Essential Tips, Tricks & Hacks - Free 156 Page Preview. Learn the most practical features and best approaches for ASP.NET.
subscribe
Programmers Heaven C# School Book -Free 338 Page eBook
The Programmers Heaven C# School book covers the .NET framework and the C# language.
subscribe
Build Your Own ASP.NET 3.5 Web Site Using C# & VB, 3rd Edition - Free 219 Page Preview!
This comprehensive step-by-step guide will help get your database-driven ASP.NET web site up and running in no time..
subscribe
Macro to export each sheet as separate Webpage
Macro to export each sheet as separate Webpage
Macro to export each sheet as separate Webpage Macro to export each sheet as separate Webpage
Macro to export each sheet as separate Webpage
Macro to export each sheet as separate Webpage
Macro to export each sheet as separate Webpage Macro to export each sheet as separate Webpage Macro to export each sheet as separate Webpage Macro to export each sheet as separate Webpage Macro to export each sheet as separate Webpage Macro to export each sheet as separate Webpage Macro to export each sheet as separate Webpage
Macro to export each sheet as separate Webpage
Macro to export each sheet as separate Webpage
 
Macro to export each sheet as separate Webpage
Macro to export each sheet as separate Webpage
 
-->