Import cell value from a file that is hyperlink opened

[Darnoky]

Hello,

I need a help. I have an excel sheet with hyperlink pathes in Column A. (e.g.:A2, A3...etc.)

My purpose is to open each of them, so loop through

and when opened one check the opened one's sheet (1).Range("BP3").Value

and paste it back to orginal excel sheet, just next to the path (that is in column B) of the opened file.
Actually I could loop through the hyperlink pathes to open them, but do not know how to "look into" the opened
file for data.

And of course close the opened file after a cell value is pasted.
One more info, all the hyperlinked files are ".CSV" files

Thank you for your help.

 

[JazzSP8]

Ah! Of course!

No problem, glad I could help and glad you realised the problem - We could have been here a while!