Auto save vba opening new file instead of just saving

[Matt Young]

Hi I know this tittle makes little sense but here goes

so I ave a few macros that clear the many sheets have for new data entry. What I want to do is to have the macro auto save with a new name in another location.
I can get it all working but the after the auto save, the new save is opened and the original is closed.
Her is the "auto save vba"

Sub AutoSave()
'
' AutoSave Macro
'

'
ChDir "C:\Users\e368464\Desktop\backup spreadsheet\AutoSave"
ActiveWorkbook.SaveAs Filename:="C:\Users\e368464\Desktop\backup spreadsheet\AutoSave\SF025 - v3.3 - Device Backup Spreadsheet" & Format(Date, "yyyymmddhhmmss") & "xlsm", FileFormat:= _
xlOpenXMLWorkbookMacroEnabled, CreateBackup:=False

Afte the save the macro works perfectly, however, the wrong fle is open (the suto save file which I am using as the backup).
Can any one shed any ligt on what I am doing wrong plese?

 

[gallen]

You aren't doing anything wrong as such. It is just how Excel works.

In order to keep open the original you will need to store its path and name then re-open once you've done the SaveAs

 

[Matt Young]

You aren't doing anything wrong as such. It is just how Excel works.

In order to keep open the original you will need to store its path and name then re-open once you've done the SaveAs

Ohhh Ok. Would "SaveCopyAs" work do you think?

 

[gallen]

Yes, that would work just remember to use the fully qualified path and file name.

My Apologies, I should have suggested this earlier.