Stopping Excel macro pattern recgonition

G

Guest

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.
 
J

Jezebel

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.
 
A

Alan

mal1920 said:
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.

Hi,

Post the code and someone should be able to help.

Alan.

--
The views expressed are my own, and not those of my employer or anyone
else associated with me.

My current valid email address is:

(e-mail address removed)

This is valid as is. It is not munged, or altered at all.

It will be valid for AT LEAST one month from the date of this post.

If you are trying to contact me after that time,
it MAY still be valid, but may also have been
deactivated due to spam. If so, and you want
to contact me by email, try searching for a
more recent post by me to find my current
email address
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top