Hi
I have to save an excel file, I'm using the saveas method in a vb6 application, and in the case of the file already esists, a message box appears..
I can Avoid this message box and save the file? or...I can get the value of the answer to this message box to manage the code

Thanks!
Milly

fName = "C:\Myfolders\Myfile.xls"
if dir(fName) < "" then
' file exists, what do you want to do
Else
' file doesn't exist, what do you want to do
End if

--
Regards,
Tom Ogilvy

"Milly" wrote in message
...
Hi!
I have to save an excel file, I'm using the saveas method in a vb6
application, and in the case of the file already esists, a message box
appears...
I can Avoid this message box and save the file? or...I can get the value
of the answer to this message box to manage the code?

Thanks!!
Milly