Fred Donahoe
New Member
- Joined
- Mar 24, 2002
- Messages
- 2
Public Sub SaveAsA1()
ThisFile = Range("A1").Value
ActiveWorkbook.SaveAs Filename:=ThisFile
End Sub
I am using the above macro in my spread sheet. If you have saved a file it asks if you wish to over write and if you say no or cancel it kicks the debugger on. How do I avoid this or get pass the error?
ThisFile = Range("A1").Value
ActiveWorkbook.SaveAs Filename:=ThisFile
End Sub
I am using the above macro in my spread sheet. If you have saved a file it asks if you wish to over write and if you say no or cancel it kicks the debugger on. How do I avoid this or get pass the error?