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

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.