How to overwrite my current active open workbook

[fluffyvampirekitten]

I wanna overwrite my active workbook
Any ideas?

Application.EnableEvents = False
        filename = Application.GetSaveAsFilename
        ThisWorkbook.SaveAs filename & ".xls"
        ThisWorkbook.Saved = True
        Application.EnableEvents = True

I have this few lines of codes.However , it created another file name instead of overwriting it
How to put all the format -
Im using excel 2013 .

ThisWorkbook.SaveAs filename & ".xls"

Thanks in advance

 

[JLGWhiz]

I wanna overwrite my active workbook
Any ideas?

Application.EnableEvents = False
        filename = Application.GetSaveAsFilename
        ThisWorkbook.SaveAs filename & ".xls"
        ThisWorkbook.Saved = True
        Application.EnableEvents = True

I have this few lines of codes.However , it created another file name instead of overwriting it
How to put all the format -
Im using excel 2013 .

ThisWorkbook.SaveAs filename & ".xls"

Thanks in advance

ThisWorkbook.Save

 

[fluffyvampirekitten]

ThisWorkbook.Save

It isn't working , it wasnt even saving . any other options ?
It doesn't overwriting

 

[JLGWhiz]

It isn't working , it wasnt even saving . any other options ?
It doesn't overwriting

If that did not save your workbook with the current changes, you either have a big problem or I am totally misunderstanding what you mean by overwrite. The syntax for saving a workbook with changes is

[I]Workbook.Save
[/I]

The Workbook can be a variable that represents a workbook object. It will save the current file with any changes and overwrite the stored file.

 

[fluffyvampirekitten]

Okay not overwrite , i wanna do "save as - "Any Name I want" "

 

[JLGWhiz]

If you want to only change the name of the file, without making any changes to the data, formulas or format in the workbook, then use this syntax:

MyOldFile.xlsx As MyNewFile.xlsx

You cannot do this with the workbook open and active. It has to be done from a different workbook than the one being changed.

 

[fluffyvampirekitten]

Ahh i see. is there any alternative? like prompt user to save a the file ?