Excel: workbooks.open problem
 

Hi,

I am making modification to already developed ASP application. Some o
the pages open a EXCEL workbooks & fill data. then provide EXCEL fil
to user through a hyperlink.

Now to develop similar new pages, i have created few more EXCE
tamplates that can be used to fill data. but to my susrprise ASP cod
is not working. it stops excution at workbooks.open method. if I try t
open existing XLS file templates, new code works fine. but it fails fo
new XLS templates. If I put some macros in old file then also ASP stop
functioning.

Do I need to set some options in XLS file to make ASP work?

Please Reply.

Thanks.
Krunal

--
Message posted from http://www.ExcelForum.com