J
JasonDev1108
I have an Excel workbook all built. Whenever it opens
it queries a bunch of data
formats it
copies it to a spreadsheet without macros or data links
then emails that data sheet to me, and some other people.
I edited the registry to make sure macro security is low.
I use schtasks to run the spreadsheet once a day.
the /TR portion of the schtasks command line is
C:\path\path\path\jason.xls
The first time I did this I used my own domain ID
for the /RU and /RP
This worked great for a couple of months
I always left my account logged in
then I had to change my domain password
and a couple of days later I realized it wasnt working
I decided to hook it to the computers local administrator account
That password doesnt change as often
I logged in as the local administrator
I set it up using schtasks and local administrator for /RU /RP
I tested it and it worked fine
I logout as the local administrator
and log back in as me and test it
I never get my email and Excel is just running hung in the back ground
Any ideas so far?
Can you think of anyway to test out what excel is going to do if it
doesnt have a good user environment?
Lets say hypothetically Excel starts up, and wants to make sure it has
a default printer
If it doesnt have a default printer it says "User should I use
PRINTER_A or PRINTER_B?"
Now if Administrator is actually logged in that default printer does
exist so excel doesnt have a question
But if Administrator is not actually logged in and it is just an
instance of Excel using Administrator's credentials
maybe a printer isnt there, maybe excel is waiting for a non-existent
user to answer a question?
it queries a bunch of data
formats it
copies it to a spreadsheet without macros or data links
then emails that data sheet to me, and some other people.
I edited the registry to make sure macro security is low.
I use schtasks to run the spreadsheet once a day.
the /TR portion of the schtasks command line is
C:\path\path\path\jason.xls
The first time I did this I used my own domain ID
for the /RU and /RP
This worked great for a couple of months
I always left my account logged in
then I had to change my domain password
and a couple of days later I realized it wasnt working
I decided to hook it to the computers local administrator account
That password doesnt change as often
I logged in as the local administrator
I set it up using schtasks and local administrator for /RU /RP
I tested it and it worked fine
I logout as the local administrator
and log back in as me and test it
I never get my email and Excel is just running hung in the back ground
Any ideas so far?
Can you think of anyway to test out what excel is going to do if it
doesnt have a good user environment?
Lets say hypothetically Excel starts up, and wants to make sure it has
a default printer
If it doesnt have a default printer it says "User should I use
PRINTER_A or PRINTER_B?"
Now if Administrator is actually logged in that default printer does
exist so excel doesnt have a question
But if Administrator is not actually logged in and it is just an
instance of Excel using Administrator's credentials
maybe a printer isnt there, maybe excel is waiting for a non-existent
user to answer a question?