No errors or dialogue boxes pop up, it seems to complete smoothly in that sense, however the window remains open.Opens another file which does the same thing i.e.However when it reaches the fourth workbook (the last one) it stops working.
Its as if Excel just skips the close commands without error and keeps going until the end of the code. The issue is when I open the previous wb which does its thing ending with code to open this workbook. Then this wbs code auto runs starting with closing the previous WB, and ending with closing itself. It fails to close itself only in this scenario but leaves the wb open and the code complete. So I cant get any error or find what is causing this code to fail. I also tried ActiveWorkbook as a 4th version of same action, still no luck. Something is preventing the wb from being closed without throwing an error. Know someone who can answer Share a link to this question via email, Twitter, or Facebook. Provide details and share your research But avoid Asking for help, clarification, or responding to other answers. Making statements based on opinion; back them up with references or personal experience. Browse other questions tagged excel or ask your own question.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
December 2020
Categories |