Greetings one and all.I have been a long time reader of this forum and have found them extremely useful in the past with help for vba coding. I now have a question to ask to which I haven't seen the answer to on here (that's not to say it's not on here though). Anyway, enough of the waffle.
I have a list of files in a column (starting at G1) that has the full path and file name of files I would like to cycle through and open to count the number of worksheets in each file and place the number of sheets in each file in column E starting at E8.
Here's hoping you guys (and gals?) can help.
Thanks
Phil B