View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default 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