Hi
Try this
'
Dim I As Integer
I = MsgBox("", vbYesNoCancel)
If I = vbYes Then
MsgBox "Yes"
ElseIf I = vbNo Then
MsgBox "no"
ElseIf I = vbCancel Then
MsgBox "Cancel"
End If
Thanks
Sanjeewa
NivaS <dilse.nivas (AT) gmail (DOT) comwrote:
Thanks alot.its working finebut can u tell me how
to capture the msgbox
YES N CANCEL values
Thanks in advance
12/2/05, Kenneth Danner <kwd (AT) nettally (DOT) comwrote:
--
You have to turn off warning messages
Application.DisplayAlerts = False
"excelobject.Sheets("sheet" & nsheet).SaveAs
"C:\test"
Application.DisplayAlerts = True
>
>
>
At 04:10 PM 12/2/05 +0530, you wrote:
>
>Hi 2 alll
>
>
>I wrote a code to open the existing excel file
,then some values adding
in
>the excel file.Saving the file with the code
>"excelobject.Sheets("sheet" & nsheet).SaveAs
"C:\test"
>
>i am getting msgbox as "A file named
"C:\test.xls" already exists in the
>location.Do u want to replace it
>
>How to write a code to capture the msgbox
"YES","N" valuesor saving
file
>with out getting this msgbox
>Thanks*DilseNivaS*
>
>
>[Non-text portions of this message have been
removed]
>
>
>
>
>
>Yahoo! Groups Links
>
>
>
>
>
>
>
>
>
Yahoo! Groups Links
>
>
>
>
>
>
>