Insert File location to many xls files

[Linda RQ]

Hi Everyone,

I have a lot of excel files in a folder that need to be evaluated as keep or
archive. Many have different names but are just different versions of the
same file....I am going to print all the files out and have our group
decide. I want the file name and location on each file. I know how to
insert this one at a time but is there a way to insert this function on all
of them at once?

Thanks,
Linda

 

[JP]

One way is a VBA routine that loops through the folder, opens each
file in turn and inserts the filename/path into a specified cell.
Crude but effective. You might want to post your request in microsoft.­
public.­excel.­programming as this is a general Excel group.


HTH,
JP

 

[Linda \(RQ\)]

Thanks JP.


One way is a VBA routine that loops through the folder, opens each
file in turn and inserts the filename/path into a specified cell.
Crude but effective. You might want to post your request in microsoft.­
public.­excel.­programming as this is a general Excel group.


HTH,
JP