vzachin
10-18-2006, 10:13 AM
Hi,
My coding saves a file to the C Drive but I always get a dialog box asking "Do You Want To Replace It"? My answer is always "YES".
Is there any way to code this?
My macro stops here and I would have to click Yes. I want to bypass this and just save the file.
ActiveWorkbook.SaveAs Filename:= _
"C:\ne.xls" _
, FileFormat:=xlNormal, Password:="", WriteResPassword:="", _
ReadOnlyRecommended:=False, CreateBackup:=False
thanks
zach
My coding saves a file to the C Drive but I always get a dialog box asking "Do You Want To Replace It"? My answer is always "YES".
Is there any way to code this?
My macro stops here and I would have to click Yes. I want to bypass this and just save the file.
ActiveWorkbook.SaveAs Filename:= _
"C:\ne.xls" _
, FileFormat:=xlNormal, Password:="", WriteResPassword:="", _
ReadOnlyRecommended:=False, CreateBackup:=False
thanks
zach