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

When they said...
When they said you are going to "Excel at life", they meant you "will be doing Excel your whole life".
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")
 
Upvote 0
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
 
Upvote 0

Forum statistics

Threads
1,214,932
Messages
6,122,331
Members
449,077
Latest member
jmsotelo

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
Back
Top