Results 1 to 3 of 3
  1. #1
    5 Star Lounger jujuraf's Avatar
    Join Date
    Jun 2001
    Location
    San Jose, California, USA
    Posts
    1,061
    Thanks
    0
    Thanked 0 Times in 0 Posts

    actions before workbook_open (xl97 / 2000)

    I have a medium size VBA app (14,000 lines of code, 27 worksheets, 15 forms, 9 modules, 25 classes) and would like to know what the heck Excel does before the workbook_open event. It takes its sweet time loading (18 seconds) and I'm curious what the overhead is and if there is something I can do about it. Do any of you experts know what goes on behind the scenes before the open event gets triggered? (Same question applies to the haps after workbook_close event.)
    Curious Deb <img src=/S/bummer.gif border=0 alt=bummer width=15 height=15>

  2. #2
    Star Lounger
    Join Date
    Jun 2001
    Posts
    91
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: actions before workbook_open (xl97 / 2000)

    Oftentimes you get a virus scan before the open -- do you see the words "requesting virus scan" in the lower left corner when you open a workbook? That could slow things down tremendously. If that's the case, you need to disable this in your virus program.

  3. #3
    5 Star Lounger jujuraf's Avatar
    Join Date
    Jun 2001
    Location
    San Jose, California, USA
    Posts
    1,061
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: actions before workbook_open (xl97 / 2000)

    Nope, no messages at all and it takes the same time with or w/o virus scanner on. I'm sure it's just the time it takes Excel to go through the increasing # of sheets, forms, classes, etc. and prepare them for viewing or whatever it does before it gets to the workbook_open() event. I'm just always curious what's going on behind the scenes (too much low level coding in my past I guess).
    Thnx, Deb <img src=/S/evilgrin.gif border=0 alt=evilgrin width=15 height=15>

Posting Permissions

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