Hello,
I'm using Excel 2013. I've got hundreds of Excel files in a folder. I want to search for some text but i don't want to open all these files one by one. I chanced across this website Search all workbooks in a folder | Get Digital Help - Microsoft Excel resource which has got the code to supposedly fulfill my needs. However, it does not work. The line
is yellow.
Could you help me to fix this code please?
Thanks.
I'm using Excel 2013. I've got hundreds of Excel files in a folder. I want to search for some text but i don't want to open all these files one by one. I chanced across this website Search all workbooks in a folder | Get Digital Help - Microsoft Excel resource which has got the code to supposedly fulfill my needs. However, it does not work. The line
Code:
myfolder = .SelectedItems(1) & "\"
Could you help me to fix this code please?
Thanks.