MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Macro to save a diagram as html.

Posted by Anders Bengtsson on February 05, 2002 10:21 AM

Would like my diagram to be saved as html so I can use it on the web. My excel workbook creates a new Diagram each day that should be saved as year_month.html where year is current year and month is current month. I know how to set this name when saving as xls so it's mostly a macro that fixes the html part i need. Doing this manually aint a problem but for some reson it doesn't get recorded if I try that :-/

Posted by Jack in the UK on February 05, 2002 11:41 AM

Why not save as JPG codes and help in archive section.. [NT]