Saving Excel WorkBook as WebPage Thru VBScript..
 

Hi,

I am trying to automate to save an Excel Sheet as a Webpage using VBScript called from SQL Server DTS package execution.

I tried two options,

1. Recorded Macro to SaveAsWeb Page and called this macro from VBScript as ExcelApplication.workbooks.Run(€œMacro€�). This works fine as long as
I have pre created file. However, I need to create multiple files on the fly and I dont know how I can use macros here.

2. Other option I tried is to use ExcelApplication.activeworkbook.SaveAs (€œFilename.HTM€�) which just renames the files as .HTM which contains garbage.
I also tried to use the above Macro code which uses ExcelApplication.activeworkbook.SaveAs FileName=€�file.htm€�, fileformat=xlhtml €¦.. but this call is failing.

Could some please provide any suggestions?

Thanks in advance.