HTML in Excel VBA

S

Sheela

Hello,

The code below was created in excel version 95. I'm using
Excel 2002 now. How do I code if I want to convert a
chart from a workbook to html format where this chart
will be published in the Intranet? What this code does
right now is it uses third party software (Paint Shop) to
convert chart in a GIF format and then transfers it to
HTML format. How do I do it directly?

Can this html chart updated automatically when there is
changes made in excel?

--------------------------------------------------
Workbooks.Open HtmlPath & "MOPSPROD.XLS"
SavePicture ChartName:="Graph",
SaveName:="MOPSPROD.GIF"
SavePicture ChartName:="mthtrend", SaveName:="MTHMOPS.gif"
Application.Run Macro:="MOPSPROD.XLS!DailyMOPS"
Workbooks("MOPSPROD.XLS").Close saveChanges:=False
---------------------------------------------------

Please advise!!!

Thank you very much for your help.

Regards,
Sheela
 

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

Excel VBA Conversion 0
Move some sheets to a new workbook, without macros, and withoutbreaking link btwn Pivot Tables and P 0
html chart and table in outlook mail 7
Can I save a copy of Excel workbook in MSSQL database using VBA? 4
Excel VBA: Reading data from HTML-file 2
Pasting HTML script to Excel 2007 converts the cells format to 'General' 0
ChartObjects Insanity - Excel 2007 7
Best format to export Excel Range to picture?? WMF?? 5

Top