+ Reply to Thread
Results 1 to 3 of 3

Maximizing vba CPU usage

  1. #1
    Forum Guru
    Join Date
    03-12-2010
    Location
    Canada
    MS-Off Ver
    2010 and 2013
    Posts
    4,418

    Maximizing vba CPU usage

    This problem has been on mind for a while and I haven't read anything concreate about it so I thought I would poll the people here. How can we force a macro to use all our CPU capacity when running? I am running a quad-core, 64-bit Excel and my macros seem to only use around 25% of the avaiable CPU capactity. On the other hand, if I update a million cells with formulas in them, Excel flexes its musceles and sucks every last drop of processing capacity to its favor. Any thoughts? Has anyone come up with a way to simulate multithreading with vba?

    abousetta
    Please consider:

    Thanking those who helped you. Click the star icon in the lower left part of the contributor's post and add Reputation.
    Cleaning up when you're done. Mark your thread [SOLVED] if you received your answer.

  2. #2
    Forum Contributor
    Join Date
    12-28-2011
    Location
    England
    MS-Off Ver
    Excel 2007
    Posts
    280

    Re: Maximing vba CPU usage

    Hi Abousetta

    VBA is single threaded so you won't get it to use all your cores.

  3. #3
    Forum Guru
    Join Date
    03-12-2010
    Location
    Canada
    MS-Off Ver
    2010 and 2013
    Posts
    4,418

    Re: Maximizing vba CPU usage

    Does anyone have any experience they want to share regarding Excel DNA? Anyone know any good resources or documentation on how to use it? It looks like a good option to be able to harness multi-core functionality with vba but I am having difficultly following their examples.

+ 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