Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Save Workbook as HTML

I am creating an Excel workbook that has 1 data tab and several other tabs
with charts based on the data. This is essentially a report that is sent to
customers with information pertinent to their accounts. The concept is that
the workbook is a template wherein the data tab is populated from Access,
save the workbook under the customer name and repeat the process for all
customers.

I would like to save the workbooks as HTML so they could be emailed or
posted on a web site. The "Save as Web Page" menu selection works except for
the fact that Excel creates a folder with the files included in each
workbook.

The question is: Can I save the workbook as a static HTML page that looks
the same as the workbook, but with all the charts embedded in the HTML so
that it can be viewed without having access to the underlying files?

I am not terribly familiar with HTML. I am using Excel 2003. I am very good
with VBA and Access and would like to accomplish the whole task through
automation.

Any help would be appreciated.

Thanks,

Steve

Any help would be appreciated.
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Save As HTML Format Issue DRHowells Excel Discussion (Misc queries) 0 June 17th 08 11:35 AM
save rows as html files Lakewoodsale Excel Discussion (Misc queries) 0 December 24th 07 06:40 PM
Save as HTML oddity c Excel Worksheet Functions 2 August 5th 05 02:55 AM
cells not right when save as html Scott Excel Discussion (Misc queries) 0 February 23rd 05 02:59 PM
save as html writenick Excel Discussion (Misc queries) 0 January 13th 05 06:25 PM


All times are GMT +1. The time now is 12:32 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"