Open File with same name from spreadsheat

[Jevora]

Hi, hope someone will be able to help me with this issue. I created an excel macro that imports the file names and listes them in a column that was part 1.

part 2 - I want to run another macro to go to lets say go to cell A2 read file name go to specific folder and open the same name file.

part 3 - is look at file and be able to select certain information and extract them and place in another spread sheet.

I want this to loop until it reads all the file names in the cell.

I thank you in advance.

JE

 

[BrianB]

Have a look at my code here which has 2 macros - one to read file names and the other to process them. Not exactly what you want but the principle is the same.

http://www.mrexcel.com/forum/showthread.php?t=322393