No errors or dialogue boxes pop up, it seems to complete smoothly in that sense, however the window remains open.Workbook opens and auto runs a private sub which calls a macro in the workbook via Run MacroName which does like open a CSV, resave as XLSX.
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. 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. 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. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
December 2020
Categories |