path and file name

[Joe Schmo]

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

 

[Guest]

You can use the View>Header&Footer>Custom>Select Path Name and File Name
buttons and click them. This will insert the Path and file name in a header
or footer(your choice), which can be seen on the printed copy of the sheet(s).