Hi
I was wondering if I can get assistance with a vba that copies visible worksheets only from a number of files in a folder into a new workbook. The issue is each of the files in the folder have hidden worksheets and I do not want the hidden worksheets just the visible sheets. And hopefully the vba can loop through all the files and copy the visible sheets into my workbook from which I ran the vba.
I appreciate your help and advice.
thanks in advance
Bookmarks