Hi, i am having problems when i try the above VBA code with xlsm files. It works ok with one file path but when i change it to search the directory i get an error of current worksheet already open. Please help - thanks
Excel VBA Course - From Beginner to Expert
200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
Fast Excel Search on Multiple Workbooks - VBA Macro
0
Discussion
The "above" code is missing.
Variatus (rep: 4889) Jan 1, '19 at 7:23 pm
You could have a million different issues and it all depends on the specific code that you used and your data setup so please include as much info as possible and also the code that you are using.
don (rep: 1989) Jan 3, '19 at 12:07 am