View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Jezebel
 
Posts: n/a
Default Stopping Excel macro pattern recgonition

Macros don't start 'recognising patterns' all by themselves. Nor do they
change their speed of operation. Beyond that, it's hard to comment about
your problems without knowing something about what the macro is supposed to
do. They don't have any inherent 'pattern recognition function' to be
crippled.



"mal1920" wrote in message
...
Hi all,
I have an Excel spreadsheet with a macro that I use to load data into a
third party program. The problem is that when the macro runs after a
couple
of repetitions, it recognises a pattern and loads all of the data from the
spreadsheet and then tries to dump it into the third party program. The
macro
then starts to go through at high speeds, not giving itself time to do the
tabbing and alt-tab between buttons/programs.

Is there some way to cripple the pattern recognition function in the
macros?

I am using the sendkeys function.