Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Stopping Excel macro pattern recgonition
"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. 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: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro Help In Excel | Excel Discussion (Misc queries) | |||
Closing File Error | Excel Discussion (Misc queries) | |||
Macro to close excel | Excel Discussion (Misc queries) | |||
passing arguments from an excel macro to a word macro | Excel Discussion (Misc queries) | |||
Excel macro that opens new MS Word file and pastes data as a pictu | Excel Worksheet Functions |