why close the open file after running the macro

[Mussa]

Hello
I have problem about close the file where running the macro from it. actually I use this

ActiveWorkbook.Close SaveChanges:=False

so far I don't find solution , any help please?

 

[portews]

This will quit the application, not just close the file. Equal to hitting the X in the corner of the window.

Try this:

'sets the flag that the workbook is saved, doesn't save it
ThisWorkbook.Saved = True
Application.Quit

 

[Mussa]

sorry I wasn't clear from the beginnig .
I don't close the file at all , just keep the file is open.

 

[portews]

Then take that line out???

 

[Mussa]

what do you mean?

 

[portews]

I'm not sure what you are trying to do. Are you just trying to close the file and leave Excel open? If so, the code you have works for me.

 

[Mussa]

Are you just trying to close the file and leave Excel open? If so, the code you have works for me.

absolutely not , the file xlsm contains macro when I run the macro should not close the file . just keep open

 

[portews]

Then remove that line. The file will then stay open.

 

[Mussa]

actually I did it , that's why I post here to solve this strange problem . I'm too lost !!!