Photo Gallery Member List Search Calendars FAQ Ticket List Log Out


vbscript excel application error

  		Logged in as: Guest
arrSession:exec spGetSession 2,2,59546
Active Users: There are 0 members and 0 guests.
Users viewing this topic: none
 

 

  
 
  Printable Version
All Forums >> [Scripting] >> WSH & Client Side VBScript >> vbscript excel application error
  Do you like VisualBasicScript.com? Link to us and help spread the word about our forum. Thanks! 		Page: [1]
Login
Message << Older Topic   Newer Topic >>
vbscript excel application error - 4/27/2008 6:54:57 PM   
  abhvar

 

Posts: 3
Score: 0
Joined: 4/27/2008
Status: offline 		Hi,

I have script written to do some excel operations. While i run this script on a server where excel is installed its works absolutely fine. But when i share it to other server where excel is not present and try to invoke excel it throws an error stating cant createobject 'Excel.Application'. Basically i want to run excel from a server where it is not installed by sharing the excel file path on the server where it is installed. Could anybody please help me on same.


Regards,

Abhay Varma
 
 
Post #: 1
 
RE: vbscript excel application error - 4/28/2008 12:16:20 AM   
  ebgreen


Posts: 4613
Score: 31
Joined: 7/12/2005
Status: offline 		Can't be done. Instead run the script on the server where Excel is installed and have it manipulate the files on the other server.

_____________________________

"... when you are good and crazy, oooh, oooh, oooh, the sky is the limit!" - The Tick
Goog places to start:http://www.visualbasicscript.com/m_24727/tm.htm
http://www.visualbasicscript.com/m_47117/tm.htm

(in reply to abhvar)
 
 
Post #: 2
 
RE: vbscript excel application error - 4/30/2008 3:07:34 AM   
  Rischip


Posts: 402
Score: 2
Joined: 3/26/2007
Status: offline 		You can try this

Set objExcel = CreateObject("Excel.Application", "RemoteServerName")

But there may be security restrictions in place on the network that prevent it from working.

_____________________________

Rischip
Author of - The Grim Linker

(in reply to ebgreen)
 
 
Post #: 3
 
RE: vbscript excel application error - 4/30/2008 3:17:39 AM   
  ebgreen


Posts: 4613
Score: 31
Joined: 7/12/2005
Status: offline 		Be aware however that the object will be created on the remote machine and not locally.

_____________________________

"... when you are good and crazy, oooh, oooh, oooh, the sky is the limit!" - The Tick
Goog places to start:http://www.visualbasicscript.com/m_24727/tm.htm
http://www.visualbasicscript.com/m_47117/tm.htm

(in reply to Rischip)
 
 
Post #: 4
 
 
 
 

If you found our site useful please link to us <a href="http://www.visualbasicscript.com">VisualBasicScript.com</a>.
All Forums >> [Scripting] >> WSH & Client Side VBScript >> vbscript excel application error Page: [1]
Jump to:





New Messages No New Messages
Hot Topic w/ New Messages Hot Topic w/o New Messages
Locked w/ New Messages Locked w/o New Messages
 Post New Thread
 Reply to Message
 Post New Poll
 Submit Vote
 Delete My Own Post
 Delete My Own Thread
 Rate Posts




Forum Software © ASPPlayground.NET Advanced Edition 2.5.5 ANSI