Looks like you are trying to write some kind of keystroke macro. Afraid
that is not something I can help you with.
Use SendKeys. Use Excel VBA help.
However, your short term solution will probably result in long term pain.
Better to invest the time and understand his code then figure out how to
integrate. I would see no userforms being shown from his application, but
you applying the data to the routines that his userforms would call. Still,
its not something I have to do and you do have to.
--
Regards,
Tom Ogilvy
"tad_wegner" wrote
in message ...
tom-
thanks for your response... i tried it (at least how i interpereted
what you wrote), however it did not work.
what happened is that my macro from workbook-A opened the userform in
workbook-B and filled it out, then paused. when i clicked the
"commandbutton" a msgbox popped up. i had to "OK" it, then the
commandbutton "action" happened. so it looks like i only
"boobie-trapped" the commandbutton on the userform, i didnt actually
get it to "click" from my macro in workbook-A. im confused...
i couldnt agree more about the method being flawed from the git-go.
without getting too wrapped up in details, the nature of what i want to
do is very complex and has many steps.
- i developed a very large tool 'workbook-A'
- another engineer developed an even larger tool 'workbook-B'. his tool
uses vast amounts of userforms to collect and display data (i know
little about userforms, but much about macros in general, according to
me)
-combining workbooks wouldnt make this easier for me, i still need to
know how to activate his userform "commandbutton"s to automate our
analyses. both processes are very iterative and do hundreds of
thousands of calcs (each) so i want to 'batch' all our macros together
so i (we) dont have to feed the workbooks any additional data after we
press the "go" button. the problem is his userforms are huge and
complicated and i dont want to look through all the code to bypass the
form... id rather fill the userform out like he wanted and submit them
like they would normally be done. BTW he is no longer here, so this
makes it very difficult.
please, can you instruct me one more time... last time it didnt work.
thanks.
--
tad_wegner
------------------------------------------------------------------------
tad_wegner's Profile:
http://www.excelforum.com/member.php...o&userid=27770
View this thread: http://www.excelforum.com/showthread...hreadid=473198