Use Application.quit after close

Is there a way to use application quit for just "thisworkbook"

I mean:

I have several workbook's open, although if i close 1 and use application.quit (i need to use this code btw), it quits all workbooks.

Is there a way to close the application but just for this workbook? so i can keep the other workbook's safe?

No Application.Quit closes Excel. You would need to use Workbook("Name").Close or Activeworkbook.close or Thisworkbook.close.

i already tested that solution, doesn't work cuz the application stills open

Originally Posted by JOHN H. DAVIS

No Application.Quit closes Excel. You would need to use Workbook("Name").Close or Activeworkbook.close or Thisworkbook.close.

Please Login or Register  to view this content.

tHIS IS what i have at moment, although have 1 problem:
Where line is bold, the file reopens after i close it, it saves perfectly, although it reopens if i have another file open

Originally Posted by MarvinP

So, you want some of the workbooks to stay open in Excel after you close Excel. I think this is impossible as closing Excel will also close all the workbooks too.

That is why I suggested only closing the specific workbook and leaving Excel open so the others were still in computer memory and working.

The bottom line is: If you close the application, all programs/files that are using that application will also close.

I know that, thats why the line is commented out. My problem is that in that line the excel reopens after i closed it. (ontime is turned off by macro 'resetandstopclock)

Please let me know what can i do

Yes as told before, i have ontime event although i stop it on before close event with macro "resetandstopclock" it works perfectly if thisworkbook is the only one open. If there is another excel ope, thisworkbook reopens after close

About buttons and shapes there are no links between workbooks, each one has its own