path and file name
 

New to VB

Is there a way I can insert in a new column (column A) the path, file, and
tab name where the data in the column to the right is not null.
Some spreadsheets contain multiple tabs also.

Also, I'd like to do this to multiple spreadsheets (appx 120) contained in a
single folder.

Thanks in advance

hi
I am having this problem from very long time but Long Path Tool helped me in this situation.
http://PathTooDeep.com all u guys must try to fix this problem