VBA in 2010 mutch slower

[RogerSt]

Hi All

I have an VBA function witch loops trough every character of a field. I analyse the character, is it Bold or Underline and write it in a textfile.

In the textfile it looks like %BOLD%character%BOLD%

If i have 1000 caracters in a field Excel 2003 takes 14 seconds for it.
Ecxel 2010 takes 35 seconds for it.

Here is a samplecode

Please Login or Register  to view this content.

Does some body know why??

Regards Roger

[MarvinP]

Hi RogerSt.

This article might explain your problem
http://msdn.microsoft.com/en-us/library/ff700515.aspx

Also see if this runs faster:

Please Login or Register  to view this content.