We are currently having a problem opening an excel workbook which has macros. We can open any xls file without macros, but the system hangs when opening a file with macros. The following is the ASP code used to open the workbooks:
Set objExcel = Server.CreateObject("Excel.Application")
objExcel.EnableEvents = False
'Add the new excel file for the results to be placed
strTemplateFile = Server.MapPath("/exports/partbuilder") & "\template.xls"
If we try opening just the template file the system will hang, but if you physically go to the server and open the template file you get no warnings about macros.
Any ideas on why we cannot open a macro enabled file via ASP?