|
Hi all I have written a powershell script that creates a workbook in preparation for a ssis data load. The script runs fine on my laptop but on the server it seems to fail almost everytime stating cannot find .add on excel com object. Any help would be hugely appreciated!
(comments are locked)
|
|
When running on the server, are you using credentials that have the right permissions? I have even tried executing the script using a .bat and run as administrator
Jan 26 '12 at 07:35 AM
chillw1nston
Turns out that being logged in as a local administrator allows the script to run. Ill just have to find out how to proxy the service or add relevent permissions to service running the script now.
Jan 26 '12 at 07:48 AM
chillw1nston
(comments are locked)
|
|
Just throwing this out there, does the server have Excel installed on it? I'm not a PS expert but I would think that you would need Excel on the server if the script is running there. Hi, yes its a dev server and includes full office install
Jan 26 '12 at 07:28 AM
chillw1nston
Same Office version that you have on your laptop? Also, I'm not sure what PS GUI you might be using, if you use something like PowerGUI (http://powergui.org/index.jspa) you can see the objects and what properties/methods are available as the script runs. Not sure if that would help, but it might give you further insight.
Jan 26 '12 at 07:39 AM
JohnM
(comments are locked)
|

