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
Answers
0
please i want to download the file
Discussion
Hi mmahgoub and welcome to the Forum.
Please log in then go to the Tutorials section (see the hyperlink above) and search under the VBA section.
For future reference, please note that your message above should be under a Discussion section really (since we generally reserve Answers for working solutions to Questions).
Please log in then go to the Tutorials section (see the hyperlink above) and search under the VBA section.
For future reference, please note that your message above should be under a Discussion section really (since we generally reserve Answers for working solutions to Questions).
John_Ru (rep: 6792) Aug 24, '25 at 3:16 am
Hi mmahgoub and welcome to the Forum.
Please log in then go to the Tutorials section (see the hyperlink above) and search under the VBA section.
For future reference, please note that your message above should be under a Discussion section really (since we generally reserve Answers for working solutions to Questions).
Please log in then go to the Tutorials section (see the hyperlink above) and search under the VBA section.
For future reference, please note that your message above should be under a Discussion section really (since we generally reserve Answers for working solutions to Questions).
John_Ru (rep: 6792) Aug 24, '25 at 3:16 am