Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
2 Label Options - Forms Object vs Control Box Object | Excel Discussion (Misc queries) | |||
Running excel macro by scheduler | Excel Discussion (Misc queries) | |||
can't use the control toolbox in excel to embed a flash object | Excel Discussion (Misc queries) | |||
Running a Excel Macro from Windows Scheduler | Excel Programming | |||
Excel 2002 / XP - Running .XLS with Macros via Task Scheduler | Excel Programming |