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

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

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



.

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



.