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

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
I have basic code running a macro in a excel sheet.
i want to set the input box automatically to yes.
Then finish running the macro...

Other idea is to:
there is a default of yes so I could do a msgbox type
of
thing with excel.Application.DisplayAlerts = False but
for a inputboxs.

Mike

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

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

--
Regards,
Tom Ogilvy



"Michael Joe" wrote in message
...


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
I have basic code running a macro in a excel sheet.
i want to set the input box automatically to yes.
Then finish running the macro...

Other idea is to:
there is a default of yes so I could do a msgbox type
of
thing with excel.Application.DisplayAlerts = False but
for a inputboxs.

Mike

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

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

thanks
-----Original Message-----
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

--
Regards,
Tom Ogilvy



"Michael Joe"
wrote in message
...


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
I have basic code running a macro in a excel sheet.
i want to set the input box automatically to yes.
Then finish running the macro...

Other idea is to:
there is a default of yes so I could do a msgbox
type
of
thing with excel.Application.DisplayAlerts = False
but
for a inputboxs.

Mike



.

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

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 :-)

--
Regards
Frank Kabel
Frankfurt, Germany

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

thanks
-----Original Message-----
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

--
Regards,
Tom Ogilvy



"Michael Joe"
wrote in message
...


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
I have basic code running a macro in a excel sheet.
i want to set the input box automatically to yes.
Then finish running the macro...

Other idea is to:
there is a default of yes so I could do a msgbox
type
of
thing with excel.Application.DisplayAlerts = False
but
for a inputboxs.

Mike



.