Export text with VBA

Hello all

First of all i work with Excel 2010.
I have an excel sheet witch has some textblocks.
I want do export this textblocks via vba.

The problem is not the export.
The problem ist the formating.
in excel a cell looks like this

-------------------------------------------------
Here is some headertext


here follow some normal text with Bold and Unerline word.


Some text with address and odther infomation and bla bla bla bla bla bla

bla bla bla bla bla bla some wath bla bla
-------------------------------------------------

(Bold parts are not shown in this text)

in the export i have to write the following:
-------------------------------------------------
%BOLD_ON%Here is some headertext%BOLD_OFF%


here follow some normal text with Bold and Unerline word.


Some text with %BOLD_ON%address%BOLD_OFF% and odther %UNDERLINE_ON%infomation%UNDERLINE_OFF% and bla bla bla bla bla bla

bla bla bla bla bla bla %BOLD_ON%%UNDERLINE_ON%some wath%BOLD_OFF%%UNDERLINE_OFF% bla bla
-------------------------------------------------

Right now i do this with this code

Please Login or Register  to view this content.

My problem ist the time witch is used.
If the cells has 1000 characters,the routine will take 35 seconds.
With Excel 2003 the same Script takes about 10 seconds.

Any idea? how i can speed up the script or is there an other function in Excel 2010?

Best regards
Roger

hi, Roger, why not to post sample excel file clearly showing your original data and result you need to obtain?