I am trying to accomplish the following:

I need to clear a XLS spreadsheet on a Network Server from
a DTS package. I originally was using a call to a Macro
that was attached to the spreadsheet. When I run this
from my PC it works fine. When I schedule it it dies. I
have found several web pages stating that you cannot use
MS applications (Macros) while in an unattended
environment. How could I get around this. I need to
clear and not re-create because I need to keep the macro
attached to the current spreadsheet for use later. Any
help is appreciated.

It is not true that you cannot use them, it is true that MS would rather you
didn't (They do not support Office automation, server side, unattended). If
everything works fine when manually executed but not when scheduled then the
following article usually helps

http://support.microsoft.com/?kbid=269074


"Barry" <anonymous (AT) discussions (DOT) microsoft.com> wrote