asked on

Excel Workbooks.Open with macros enabled via ASP

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
objExcel.Workbooks.Open strFileName
'Add the new excel file for the results to be placed
strTemplateFile = Server.MapPath("/exports/partbuilder") & "\template.xls"
objExcel.Workbooks.Open strTemplateFile

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?

Thanks,
Rottie

Brian Mulder

Hello Rottie,

maybe a rights issue? sounds like it since you're probably logged in as admin when opening the file directly on the server

if you leave this line out
objExcel.EnableEvents = False

do you get any warnings instead of the *hang*?

HAGD:O)Bruintje

Brian Mulder

btw where are the macro's placed?

Rottie

ASKER

I'll give that a try in a few minutes and let you know if there are any warnings.

I never thought about permissions being an issue since we can open other files (without macros). Do you know if excel requires specific user permissions?

Thanks,
Rottie

Rottie

ASKER

I commented out the enable events and it made no change. How can we get the application to be viewable on the server when called? We can see it in taskmanager, but is there any way to see it in the taskbar, etc to check what's going on?

My only other option at this point is to setup a local IIS server and experiement that way.

Any other ideas?

Thanks,
Rottie

Brian Mulder

to see excel

Set objExcel = Server.CreateObject("Excel.Application")
objExcel.visible = true

no not many other ideas then testing we played with the idea of doing this setup but still are running batch updates from excel to html components that are linked through in ASP.......primitive i know :)

i'm curious what you can see i think there will be a box the alerts will not be shown if the object is invisble stupid that i think only now of that

Brian Mulder

Hello Rottie

this question is open for more then 2 months
time to clean up
if not stated otherwise

my recommendation will be
-PAQ and refund
-this will be finalized by an EE Moderator
-with no further update (23.11.2002)

PLEASE DO NOT ACCEPT THIS COMMENT AS ANSWER

HAGD:O)Bruintje
posted by ToolzEE v1.0

ASKER CERTIFIED SOLUTION

Netminder

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial