Do you use Select in your vba code? Does the screen flash all over the
place while your code is running?
If so, you might be able to dramatically increase the speed of your macro by
not using select or by setting ScreenUpdating = False and turning
calculation off.

--
Regards,
Tom Ogilvy

"Thomas Kregeloh" wrote in message
...
Hi,
excuse my cross-posting, but I do not know which NG is the appropriate for
my problem.
I wrote an Excel-Macro in VBA which reads a text file, interprets this
file
and then does in Excel what has to be done: format cells, put values to
it,
storing files, inserting worksheets etc.
This works well, as designed, but is not very fast.
So I look for a way to increase speed.
I have Visual C++ 6 in Visual Studio. Can I rewrite my macro in Visual C++
so that it gets faster? If yes, where do I find "easy to understand"
descriptions how to do this? What do I need additionally?
TIA
Thomas Kregeloh