C
Chiefen
I have on macro that is copying one sheet into another workbook and
would like to save it with ref. to cell A1. It has to be saved in same
folder as the original workbook regardless if I move the original
workbook to another folder.
Sub Macro1()
Sheets("sheet1").Select
Sheets("Sheet1").Copy
ActiveWorkbook.SaveAs Filename:= ????????
FileFormat:=xlNormal, Password:="", WriteResPassword:="", _
ReadOnlyRecommended:=False, CreateBackup:=False
ActiveWindow.Close
End Sub
would like to save it with ref. to cell A1. It has to be saved in same
folder as the original workbook regardless if I move the original
workbook to another folder.
Sub Macro1()
Sheets("sheet1").Select
Sheets("Sheet1").Copy
ActiveWorkbook.SaveAs Filename:= ????????
FileFormat:=xlNormal, Password:="", WriteResPassword:="", _
ReadOnlyRecommended:=False, CreateBackup:=False
ActiveWindow.Close
End Sub