![]() |
Excel running when user is not logged in to windows
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? |
All times are GMT +1. The time now is 01:59 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com