Posted on 2004-11-16
Last Modified: 2010-05-02

There is a VB procedure. It makes thousands of calculation.
This procedure is running on a Windows XP system with dual processors in HyperThread mode to emulate 4 processors. It takes 20 minutes to complete the calculation.
I am not experienced on hyperthreading (actually even multithreading). This is a curiosity question (also as I am almost sure that it couldn't be possible to use different CPUs for the same process in same application's same session but it wouldn't hurt if I am wrong!).

This is the all information I have.

Question: Is it possible to split the "same procedure" to make it processed by "4" CPUs at the same time and reduce the processing time less than 20 minutes (consider 20 minutes is the best time)?

BTW: It is actually a VBA module that works in Excel 2003 application but I am willing to update it by using a COM-Addin that is created by VB if such a thing is  possible.

PS: I will be able to read replies tomorrow, so I might not reply soon.
Question by:smozgur
    LVL 48

    Assisted Solution

    LVL 4

    Accepted Solution

    LVL 17

    Author Comment

    Ok, It has been ended as I expected.

    Thanks for the replies and links.


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Introduction In a recent article ( for the Excel community, I showed an improved version of the Excel Concatenate() function.  While writing that article I realized that no o…
    This article describes some techniques which will make your VBA or Visual Basic Classic code easier to understand and maintain, whether by you, your replacement, or another Experts-Exchange expert.
    Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
    This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now