save chart from excel as html


Posted by Lu Brundage on May 18, 2001 10:51 AM

I have been able to manually save a chart in excel by clicking on file and using saveas html. However, I want to be able to do this in code, is it possible? I have tried to use something like sheet114.saveas and then give the filename but the file formats that I have seen that are available do not support HTML. Am I missing something somewhere? Any help on this would be great.

Thanks



Posted by Tom Bellmer on May 18, 2001 12:10 PM

.ActiveWorkbook.SaveAs(lcHTMLName, xlHTML)