Hi everyone,

first of all: thanks for your time to open this thread.

Now to my problem - The thread name is just the begining of the challange Im facing.

In my sheet, I have numerous filenames together with their localization. I.E. "C3" = C:\Test\Friday\TheFileImUsing.xls

I would like excel to open each of those files, do some calculation that will be done with some other code(which i already have), close the file, and then open the next file in collumn C (if there is a next one that is).

Furthermore, I would like to be able to call each workbook that is opened HP1, HP2, HP3...

Thanks!

Book3.xlsx