System not adequate

Bugs

Board Regular
Joined
Aug 21, 2002
Messages
100
Does anybody have any ideas on a macro that
can report if the system being used is not adequate for the macro's running.
Reason i have made a spread sheet which works fine on my pc Pentium 3 1.2GHZ
the spreadsheet is used by a lot of people
however i have some people complaining the spreadsheet is not usable as it is to slow.
It would be great if there was some code that
timed macros and reported if was too slow

Msgbox ="System not adequate to run this program Pentium 733 Mhz or better"
 

Excel Facts

Wildcard in VLOOKUP
Use =VLOOKUP("Apple*" to find apple, Apple, or applesauce

VoG

Legend
Joined
Jun 19, 2002
Messages
63,650
You can time your code like this

Dim tm As Date
tm = Now()
'your code to time goes here
MsgBox Format(Now() - tm, "hh:mm:ss")
 

XL-Dennis

Well-known Member
Joined
Jul 27, 2002
Messages
1,920
bugs,

How large is the file?

Why a workbook might be running slow on some machines is not necessary related to the processor itself!

- Available RAM.
- If the temp-directory is full with temp-files.
- If there exist lot of *.emf-files
- Different version of XL may act different depending on what Your workbook does.

So before You start to dig into processors - check up these things first.

Kind regards,
Dennis
 

Watch MrExcel Video

Forum statistics

Threads
1,130,046
Messages
5,639,761
Members
417,109
Latest member
996

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top