Hi all,
I've tried to search for this but no joy as what I have found all use 'ThisWorkbook' as a starting point. If anyone is willing I require some simple code which points to a the workbook I want closing and then closes it without saving. The workbook will be open.
I tried making that workbook active (.Activate) and then using ThisWorkbook.close but it didn't work.
Can anyone help?
(using 2010)
Try this,
Please Login or Register to view this content.
Happy Computing ,
Xlbiznes.
To show your appreciation please click *
That is wonderful. Thank you very much. May I ask, I have the following at the end of my code which is intended to close and save the remaining workbook. Whilst it does this it still leaves Excel open (just with no workbooks open). Do you know how to close Excel completely?
Please Login or Register to view this content.
How did you create/open the workbook you want to close?
If posting code please use code tags, see here.
this will do the job.
Please Login or Register to view this content.
Last edited by xlbiznes; 12-24-2013 at 06:06 AM.
I'm afraid that didn't work xlbiznes. Excel is still 'open' (even though the workbooks are not) - I can still see the ribbon at the top of the screen.
Hi, plumby,
maybe just save the workbook and then quit?
Please Login or Register to view this content.Ciao,Please Login or Register to view this content.
Holger
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
I thinkPlease Login or Register to view this content.
Arrgh. Still no luck. This is what I'm running. The first bit closes another workbook without saving just fine. The last bit doesn't work - I need it to close AND SAVE the workbook (the one that has the macro) and then exit Excel completely.
Please Login or Register to view this content.
Hi, plumby,
do you mind just using the code lines I sugested and not the ones you believe to be correct? Result should be as you wanted if you donīt close the workbook with code prior to closing Excel.
Ciao,
Holger
Hi HaHoBe,
Apologies, yes I seemed to have overlooked your code. I have tried it but Excel is still open. I have pasted my entire code with comments. It's the last two pieces which close a different workbook with saving (which works) and the very last routine which is meant to close the workbook which the macro is stored in (this is the one I cannot get to work).
I have pasted all the code just in case there is something I am doing early on which is causing problems.
Please Login or Register to view this content.
Hi, Plumby,
where is the difference between Workbooks("PBH slicers1.xlsm") and ThisWorkbook?
From what I guess:
Ciao,Please Login or Register to view this content.
Holger
Thank you for this. It's very kind of you to take the time.
I receive the 'Object doesn't support this property or method' on this line:
Please Login or Register to view this content.
Sorry HaHoBe I forgot to answer your initial question. Yes, Workbooks("PBH slicers1.xlsm") and ThisWorkbook are the same thing.
Hi, Plumby,
maybe set an object for the worksheet to which to copy?
Ciao,
Holger
Sorry, I don't understand?
Hi, Plumby,
I get the error as well, maybe try this altered code:
Ciao,Please Login or Register to view this content.
Holger
If application.quit is not doing the job ,
We can force close excel using shell, try this.
Please Login or Register to view this content.
Hi, xlbizness,
from where since that would imply improper coding (resolving the objects not in the opposite way of setting them) and that the workbook has been closed - definitely not from the code posted here, or am I wrong on that?
Ciao,
Holger
@HaHoBe ,
i am sorry i could not understand the context of your post.
Hi, xlbiznes,
where in the code (like published in #17) should that sniplet be placed?
Ciao,
Holger
@HaHoBe,
We can place that after the application.quit statement.
As we are trying to force close excel.This statement would be to the very end.
Hi, xlbizness,
There will be no workbook with the code available to run that code after Application.Quit for that instance Iīm afraid.We can place that after the application.quit statement.
Ciao,
Holger
I'm really confused. I wish I could just close Excel after the two workbooks have closed.
HaHoBe,
The issue is that application.quit is not doing what it is supposed to do. Hence taskkill is our last resort.
According to @Plumby , excel is still active. On Excel 2007 application.quit closes excel completely.
This is what Excel looks like after I run the macro.
(xlbiznes I've yet to run your code - will do shortly)
Excel screenshot.jpg
Hi, Plumby,
you' re working with multipleinstances of Excel it seems but didnīt mention that (assumed was one instance from the poor information delivered).
@xlbiznes:
Who says so? Application.Quit can only quit one instance of Excel, and if TO doesnīt mention multiple instances that it still does the job. And again: no chance with the code supplied.The issue is that application.quit is not doing what it is supposed to do.
Ciao,
Holger
Apologies for the poor information.
@HaHoBe,
the op said so ? We are talking in context to what the OP is facing.
@HaHoBe ,
Even the 1st instance is not closed, if you can see the image which the @Plumby has posted.
@Plumby,How many instances of excel are running when you are running this macro ?
@Plumby,
did you try the shell command ?
Please Login or Register to view this content.
Ok guys this is what happens.
I have no workbooks open.
I then open one workbook (PBH slicers1.xlsm) by double clicking it, that sets off a Workbook Open Event macro which opens in turn this - Post Book.xls. When it is finished no other workbooks will be ever be open as I plan on running it at 6am in the morning using Task Scheduler.
At the end of the macro I then need to:
- Close and save PBH slicers1.xlsm
- Close and NOT save Post Book.xls
- Quit Excel (2010)
I'll try now...
Just tried it and it works!
Great and thank you for the reps.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks