Calgarypuck Forums - The Unofficial Calgary Flames Fan Community - View Single Post

jwslam · 12-19-2016, 04:13 PM

Hey all,
Looking for some expert advice here.

So I have a bunch of forms filled out in workbooks in a bunch of random folders:
Filepath1\Form1.xlsx
Filepath2\Form2.xlsx
Filepath1\Form3.xlsx
Filepath3\Form4.xlsx
Filepath2\Form5.xlsx
etc.

So currently I have a workbook containing the file names i.e. the sheet contains:
Filepath1\Form1.xlsx
Filepath2\Form2.xlsx
Filepath1\Form3.xlsx
Filepath3\Form4.xlsx
Filepath2\Form5.xlsx

How do tell excel to, in Column B, open up each of these workbooks, go to sheet 2, and extract info from cell D4?

Probably need some excellent programming skills.

Thanks guys!

12-19-2016, 04:13 PM	#1
jwslam Scoring Winger Join Date: Jul 2014 Exp:	Excel Lookup Help Hey all, Looking for some expert advice here. So I have a bunch of forms filled out in workbooks in a bunch of random folders: Filepath1\Form1.xlsx Filepath2\Form2.xlsx Filepath1\Form3.xlsx Filepath3\Form4.xlsx Filepath2\Form5.xlsx etc. So currently I have a workbook containing the file names i.e. the sheet contains: Filepath1\Form1.xlsx Filepath2\Form2.xlsx Filepath1\Form3.xlsx Filepath3\Form4.xlsx Filepath2\Form5.xlsx How do tell excel to, in Column B, open up each of these workbooks, go to sheet 2, and extract info from cell D4? Probably need some excellent programming skills. Thanks guys!