+ Reply to Thread
Results 1 to 2 of 2

Will using a "personal macro workbook" slow down my other VBA code

Hybrid View

  1. #1
    Stacymm
    Guest

    Will using a "personal macro workbook" slow down my other VBA code

    I have a several VBA procedures that read and process large (+50M) data
    files. I am trying to do everything I can to optimize the speed.

    Up until now, I was unfamiliar with "personal macro workbook". I would like
    to use it for some of the macros that I use daily, but are stored in
    individual workbooks.

    If I starting using the "personal macro workbook", when I process my my
    files, will it slow my programs down even more?

    I currently am using Excel 2003. Thanks in advance

  2. #2
    Mike Fogleman
    Guest

    Re: Will using a "personal macro workbook" slow down my other VBA code

    Where the macros reside when they are run should make no difference in their
    speed. How you write the macros will effect speed by avoiding selections,
    screen updating, re-calculations, be aware of alerts and error handling,
    etc.

    Mike F
    "Stacymm" <Stacymm@discussions.microsoft.com> wrote in message
    news:7C1F0DF6-D71A-491C-AD58-0175750FA09E@microsoft.com...
    >I have a several VBA procedures that read and process large (+50M) data
    > files. I am trying to do everything I can to optimize the speed.
    >
    > Up until now, I was unfamiliar with "personal macro workbook". I would
    > like
    > to use it for some of the macros that I use daily, but are stored in
    > individual workbooks.
    >
    > If I starting using the "personal macro workbook", when I process my my
    > files, will it slow my programs down even more?
    >
    > I currently am using Excel 2003. Thanks in advance




+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1