I am trying to run an Excel AutoOpen macro using Excel 2002 and Windows XP. When I try to use task scheduler to execute a dos batch command to open the Excel file and have it run the macro code the procedure works fine except for when the machine is under the windows password screen saver mode. I need to run the code at night and leave the machine up and running with the password protection enabled. I get a message of "Not enough system resources to display completely". As soon as you click the OK button the thing runs. Is there a way to stop this error message? I have found that I can run an Access macro that kicks off the same Excel macro and it works OK so I doubt that the problem is a system resource. I would like to avoid the extra Access step if I could to get this to run.
Tue Nov 26, 2002 7:40 pm
Joined: 19 Feb 2002
Location: Southeastern Pennsylvania
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
All contents Copyright 1998-2004 by MrExcel.com
If you believe information posted here is from your copyrighted source, notify us per the
Excel is a registered trademark of the Microsoft Corporation. MrExcel is a registered trademark of Tickling Keys, Inc.