Why vbscript could not start Excel application with CreateObject("Excel.Application") on windows 7?

Hello,

Background: vbscript is located on windows server 2003, the client is on windows 7 with IE10 and Excel 2010. The asp page is calling the vbscript to open excel file on windows 7. (xls).

Issue: set app = CreateObject("Excel.Application")  is causing the problem as app is not set and the error is: Could not start Excel application.

Could I get a hint where to look at to attack this issue? Thx in advance

May 21st, 2015 9:09pm

Hello,

Background: vbscript is located on windows server 2003, the client is on windows 7 with IE10 and Excel 2010. The asp page is calling the vbscript to open excel file on windows 7. (xls).

Issue: set app = CreateObject("Excel.Application")  is causing the problem as app is not set and the error is: Could not start Excel application.

Could I get a hint where to look at to attack this issue? Thx in advance

Free Windows Admin Tool Kit Click here and download it now
May 21st, 2015 9:09pm

Hello,

Background: vbscript is located on windows server 2003, the client is on windows 7 with IE10 and Excel 2010. The asp page is calling the vbscript from windows 7 to open excel file on windows 7. (xls).

Issue: set app = CreateObject("Excel.Application")  is causing the problem as app is not set and the error is: Could not start Excel application.

Could I get a hint where to look at to attack this issue? Thx in advance
May 22nd, 2015 3:07pm

Re:  creating an excel.application

I wasn't going to respond to your question, as it is out of my comfort range.
Since it has been a day and you have now posted on a second forum (frowned on), I'll say this...

How is "app" declared?  It should be As Object or As Excel.Application.
Also, I think that in order to start  an Excel application on your server, you need Excel installed on the server.

This MS article might be of help...
"Considerations for server-side Automation of Office"
 https://support.microsoft.com/en-us/kb/257757/en-us?wa=wsignin1.0

'---
Jim Cone
Portland, Oregon USA
free & commercial excel programs (n/a xl2013)
http://jmp.sh/K95N3ee
Free Windows Admin Tool Kit Click here and download it now
May 22nd, 2015 9:03pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics