I have a Macro which prompts the user to select files to analyze then it opens each workbook propmts the user to answer some yes/no questions and select some cells. After the user responds to the message and input boxes the macro analyzes the open workbook and pastes relevant data to a masterworkbook. The macro closes the workbook and then proceed to the next file.
The problem I am having is the macro will prompt the user to select the files open the files and then stop, no error messages, nothing.
Then if I go back to the masterworkbook and start the macro again it asks me to select the files again but when it goes to open them it says the first workbook is already open. I click open anyway and it then it goes to the questions it should be asking, however when it gets to the inputbox that asks for the user to select a cell it won't allow the user to activate the openworkbook to select the cells they need to.
The code is below:
Please Login or Register to view this content.
Bookmarks