Quote Originally Posted by John.Greenan
Most folks are very helpful on this forum, but I doubt you'll get any takers
to download your vba code and run it; it's not very sensible for security
reasons - how would they know what your code does?

--
www.alignment-systems.com


"astrikor" wrote:

>
> I need a new pc or laptop and would appreciate help to find a machine
> which will run my excel VBA data processing macros as fast as possible.
> If you are up for the challenge, contact me at astrikor@yahoo.com and I
> will forward my 1.4MB excel benchmark test file for you to run and
> respond.
> Thanks
> Astrikor
>
>
> --
> astrikor
> ------------------------------------------------------------------------
> astrikor's Profile: http://www.excelforum.com/member.php...o&userid=31465
> View this thread: http://www.excelforum.com/showthread...hreadid=519285
>
>
Thanks John, I appreciate the comment. Maybe it would help to explain what my test macro does.

It is a self-contained file in which the macro first asks the user if they wish to continue. The file contains all the data and code needed to calculate the runtime. It finishes by requesting the user to email me the result.

The macro takes one of a sequence of data strings from one worksheet, pastes it to a second worksheet where the string is processed by predictive algorithms and cell formulae, the results of which are logged into a third worksheet. The macro then returns to the first sheet to collect the next data string.There are hundreds of data strings, each containing hundreds of data points. It is intensive data manipulation.

With a target runtime of 10 seconds, anything better will be great.

Regarding security, the file has a Digital Self-Certificate.

Astrikor