I am writing a piece of code for excel to back up a worksheet to a location before it runs another routine.
My problem is how to close the saved worksheet and activate the source worksheet.
Open_Name = ActiveWorkbook.FullName
My_date = Format$(Now, "mm-dd-yy")
Path = "C:codetestackup"
ActiveWorkbook.SaveAs Filename:=Path & "dave-" & My_date & ".xlsm", FileFormat:=xlOpenXMLWorkbookMacroEnabled
MsgBox ("File has been saved to " & Path & " as " & "dave-" & My_date & ".xlsm")
<><> the active workbook is now located in codetestackupdave-My_date
but I want to open and activate Open_Name and close Dave-my_date
please help. <><>
thanks for any help you folks can provide.