Answer msgbox with macro

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

HI - 14 Sep 2007 14:59 GMT

Hei!

My problem is following. My macro uses another macro created by other
person. I cannot modify or even see the macro. After compliting that
other macro I get msgbox telling me it is done. Now I want to answer
that message automatically with macro. How can I do this?

code is something like this

'myCode
call problemMacro
'problemMacro code which I can't see
msgbox("Refresh succeeded") <- I want to automatically answer yes
'more code I can't see
'myCode

Reply to this Message

Mike Fogleman - 14 Sep 2007 15:40 GMT

You can't answer a msgbox that way. The only thing that would work is to
remove the code line that creates the msgbox. If you can't see the code,
then you can't do that either. If you can't see the code, then it is
password protected, which means you can't add more code to answer it with
even if there were such a code. You're stuck with it! (you can buy a
password remover.)

Mike F

> Hei!
>
[quoted text clipped - 11 lines]
> 'more code I can't see
> 'myCode

Reply to this Message

HI - 14 Sep 2007 15:53 GMT

Thanks, Mike!
This problem was driving me nuts. Basicly the msgbox is created by an
add-in which is indeed protected. So I guess I just tell people in my
office to push that damn putton to complite the macro.

> You can't answer a msgbox that way. The only thing that would work is to
> remove the code line that creates the msgbox. If you can't see the code,
[quoted text clipped - 20 lines]
>
> - N?yt? siteerattu teksti -

Reply to this Message