Excel Object in VB when running under scheduler control

P

Peter Hoyler

Hello;

I've done a VB program that opens an Excel Sheet Object
and writes some data into it from Access. It works fine
when I activate the .cmd file that starts the program, but
if I automate it by means of the build-in MS scheduler, it
gets an error when the program does "Set objexcel =
CreateObject("Excel.Sheet")". I should add that I only get
this error when running on a server. The program can run
under scheduler control on my own labtop without problems.
I use the same user ID on the server and in the Scheduled
Task (Run as: <user ID>.)

Thank you for any help.

Regards Peter Hoyler
 
P

Patrick Molloy

The object can only be created IF excel is
installed...and I'd be surprised if your server had excel
installed - most IT depts don't allow progs to run on
remote servers as there's too much risk involved.
 
P

Peter Hoyler

Thanks for the answer, but Excel is installed. In fact it
works fine as long as I don't use the scheduler. If I sign
on to the server by MS Terminal Client and dubbel-click
the .cmd file that starts the program, it runs fine. But
when I run the .cmd file through the scheduler, I get the
error. Both ways works ok on my labtop.

regards peter

regards peter
 
Top