Increase "CPU Usage" when running macro

[alextang0112]

Hi guys,

My PC is Win7 64bits, Office 2010 Professional, i7-930 4C8T CPU.

I run a macro in VBA, and the macro consist of 3000 loops with each loop varibles starting from 0 to 15000.

The information of CPU usage in windows task manager always shows about 30% when the macro is under way.

The time it cost is about 12mins.

I'm trying to find any informantion about how to make my PC work more efficiently (raise the CPU usage).

But it seems that the number of supported threads in VBA is only one.

Is that true ? Or actually there exist any setting that can boost the cpu usage when running macro ?

Thanks.

 

[Scuderia]

Hi

It depends on what your macro is doing as to what the limiting factor is. One thing you can do is to increase the priority the Excel Application.

Some VBA code to do this can be found here... http://www.mrexcel.com/forum/excel-...-shell-command-visual-basic-applications.html

If you have other applications are running at the same time then it could certainly help