saving excel sheet from ASP update

[Paul W.Schu]

When sending data to an excel sheet from an Active Server
Page, is there a script of some kind that will save the
workbook. It seems that when the data is sent the
workbook doesn't see it as an update so it won't autosave.

 

[Bill Lunney]

Just use the standard Workbook Save/Save As method.

ActiveWorkbook.Save(filename)

--
Regards,


Bill Lunney
www.billlunney.com