excel.application.run macro1 --> added code to respond "yes" to a inputbox

[Michael Joe]

message2
the input box comes up. i want to in vb code (outside
excel) run the macro and say yes to the input box ?
so no pop ups


message1

 

[Tom Ogilvy]

Not possible if the situation is portrayed correctly. (a VBA generated input
box).


Perhaps you mean a warning dailog or prompt coming from Excel itself. In
xl2000 and later, you can suppress most of these with


oXLObj.Application.DisplayAlerts = False

 

[Guest]

let someone else respond that is why i did this again.

thanks

 

[Frank Kabel]

Hi
no need for reposting (just the opposite). Your other message would be
read by other people as well and if they think they could add something
to Tom's original response they would.

Frank
P.S.: Just as additional note: If Tom has no answer then there just
probably is no one