Hey guys.
I have a Excel VB code that looks at multiple sheets but it stops to ask me do I want to reopen the sheet etc. I need this code to run without asking me questions. What can I add into the code to force it to run without asking me questions?
I'm not sure if it will display the image I attached but it pops up after opening each file with the following: file name.xls is already open. Ropening will cause any changes you made to be discarded. Do you want to reopen file name.xls yes or no.
This is quite strange as I was running this code in Excel 2003 and it didn't give me problems but now I have 2013 pro version. It looks like it does it on the same file. I need to grab and info from different sections in each file and place them in rows next to each other. Please remember that this worked in an earlier version of excel.
I see now it asks me 5 times per file if I want to reopen the file with every loop it runs. Do you maybe have a section of code I can add to my current code to just go ahead and reopen?
This code looks thru hundreds of excel files and I cannot sit and click yes yes yes yes lol.
Please see code below.
Thank you all for the help.
Bookmarks