Hi guys,
So I found this thread from a while ago (2008) https://www.mrexcel.com/forum/excel-questions/361577-wait-till-workbook-opens-calculates.html and the idea behind it is exactly what I want, for my code to wait until the workbook is open. In my case (and maybe just because this was used with a much older version), I keep running an error where it thinks the workbook I want to open is corrupt. I'm not sure if it's due to that this code was made with a much older version, or for some other reason. My code before this is basically doing a "save as" to rename a file, which usually automatically opens the new file you saved. Not sure if this could run that error. Anyway, thanks for any help you guys got!
So I found this thread from a while ago (2008) https://www.mrexcel.com/forum/excel-questions/361577-wait-till-workbook-opens-calculates.html and the idea behind it is exactly what I want, for my code to wait until the workbook is open. In my case (and maybe just because this was used with a much older version), I keep running an error where it thinks the workbook I want to open is corrupt. I'm not sure if it's due to that this code was made with a much older version, or for some other reason. My code before this is basically doing a "save as" to rename a file, which usually automatically opens the new file you saved. Not sure if this could run that error. Anyway, thanks for any help you guys got!
