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

Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college

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
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,164,434
Messages
5,837,222
Members
430,485
Latest member
DavevonD

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