Auto Click Userforms

[helpexcel]

Hi,

I'm not sure if if this can be done, but i figured I'd ask. I have code that opens another workbook and changes data, which generates a userform that you must then click OK for the code to continue running. Is there a way to "bypass" that userform, by writing code that will click the "OK" button?

Thanks!

 

[Yongle]

I have code that opens another workbook and changes data, which generates a userform that you must then click OK for the code to continue running

Does the userform simply require unloading?
- please post the code behind the "OK" command button

 

[helpexcel]

unfortunately, i can't get the code. I think one is an unload only, but there is another that is not. Thanks for responding!

 

[Greg Truby]

I, too, would advise trying to get ahold of the code behind the OK button. That's definitely the more robust option.

But if that's just not possible, then search here for threads on the subject of SendKeys. That should get you started. Post back if you get stuck after having played with SendKeys a bit.

 

[Yongle]

Surely someone has access to the code. Could that person modify it?

be very careful if you try to use sendkeys
- a user clicking on "OK" waits until the button is there
- VBA does not wait unless forced to!

 

[Norie]

How is the userform 'generated' in the other workbook?

If it's via event code you could disable events in your code, open the other workbook, change the data, close the other workbook and enable events again.

 

[Jaafar Tribak]

Does the code opens the new workbook in the same excel instance or in a seperate one ? And is the UserForm Modal or Modeless ?