Possible to find new file location with last known old location in VBA

[Bassie]

Hi everyone,

I have a list of path files in my excel sheet and sometimes these paths change for whatever reason. Is it possible to find the new file path location automatically based on the last known old location?

Regards,
Bassie

 

[Herakles]

Are you saying that you want to find out where each of the files is now?

Does each file have a unique name?

 

[Bassie]

Are you saying that you want to find out where each of the files is now?

Does each file have a unique name?

I would like to know where the files are even if the file name or file path changes. Not sure if this is even possible

 

[Herakles]

It is the file name and it's path that identifies it.

The combination of these two represents a unique reference.

I don't think that it is possible.

 

[Bassie]

It is the file name and it's path that identifies it.

The combination of these two represents a unique reference.

I don't think that it is possible.

Thats what i was afraid of sadly. Is it also not possible to add a categorie or label to the file to make it unique?

 

[Herakles]

It is the combination of the file name and it's path that are the label and it's category in effect.

 

[Bassie]

It is the combination of the file name and it's path that are the label and it's category in effect.

Alright thanks for your help!

 

[Herakles]

Are these all Excel files?

 

[Bassie]

Are these all Excel files?

Not exclusively but some are