Excel Auto_Open macro and system resources error message

Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Excel Auto_Open macro and system resources error message

  1. #1
    New Member
    Join Date
    Nov 2002
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    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.

  2. #2
    MrExcel MVP Anne Troy's Avatar
    Join Date
    Feb 2002
    Location
    Arlington Heights, IL
    Posts
    2,572
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Can't you use the

    Application.DisplayAlerts = False

    and then =True after the code is complete.
    ~Anne Troy

  3. #3
    New Member
    Join Date
    Nov 2002
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    I already tried placing that in the first part of the macro but it doesn't stop this particular message.

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com