I wrote a massive text replacement macro but it's very slow. my system info "Processor Intel(R) Core(TM) i7-2630QM CPU @ 2.00GHz, 2001 Mhz, 4 Core(s), 8 Logical Processor(s)". How can I optimize the VBA and make it replace the text faster.
Good afternoon RangaliaCould you share the VBA in a text document for assessment?A faster more up to date processor will always help too; but i am working on an i7-3770 @3.40GHz with 32GiB Ram and don't experience delays in my macro's.
Are you using the optimization code in your macro?
Sub YadaYada()Optimization = True__________________
your code to make things happen
__________________
Optimization = False ActiveWindow.RefreshEnd Sub
Even with Optimization = True (as suggested by Myron), some text operations in CorelDRAW can be very slow.
That includes both (1) large numbers of text shapes and (2) individual text shapes that have a large number of characters.
I write that from personal experience; I don't know how those affect the specific types of text operations that you are trying to perform.