Hello,
please can You help me ?
How I can to reduce running of some actual macro code ?
Thank You
Radovan Zigraj
Printable View
Hello,
please can You help me ?
How I can to reduce running of some actual macro code ?
Thank You
Radovan Zigraj
Optimise it?
You'd have to look online for optimisation trick depending on your db.
Indexes on fields? (slows input slightly but allows faster returning of records).
When you say Macro .. do you mean vba code? Or Access Macro?
Perhaps it is the amount of data or the way that you have it structured?
Sorry,
I mean macro code in VBA in MS Excel.
What are you doing at the moment in excel?
There are a few ways you can try to slow down the code..
1. Sleep function to pause execution
2. Empty Loops (Not the best method)
3. Loop until a certain condition is true.. (the best and most efficient method)
It will depend on what you are trying to do, so if you could post why you need to slow it down we might be able to give some further information
uhh dnany ... I believe they want to make it run faster (reduce time) .... ;)
Hmm,, the title states running it slowly.. :confused:
My macro code is reading on one sheet row per row and evaluating condition ( if ).
If this condition is true than macro is going to copy this row and put on another sheet and again activated prevous sheet.
How I can be sure that were processed all rows ?
Ok so now I'm really :confused: are you trying to speed up, slow down or validate the process??
Can you post your code, so that we can review it?