SaveAs and Replace File
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
|