Need to import a single cell value from thousands of csv - Without opening a dialog box ev

Hello guys

I have a master spreadsheet with summaries, stats, and observations on about a thousand experiment results and ongoing. Each row corresponds to a unique experiment ID#. The instrument I use also generates a csv with the same name as the experiment ID#.

I have tried several other options, but the following formula gets me closest:
=(\\companyname.com\storage\[1010015216-results.csv]1010015216-results!B11)

It creates a dialog box asking me to locate the file. I don't want to locate the file every single time, I just want it to import the text values in cell B11 from the csv at that filepath from that sheet automatically. Previous solutions I have found here and elsewhere were from people wanting a dialog box prompt to open to locate their files.

Hopefully, I am missing something simple here one of you guys could point out.


Additionally, I am using a column with the data source filepath (\\companyname.com\storage\) and concatenating with the experiment ID# in the master spreadsheet (1010015216-results.csv) to generate the full csv source filepath I use in my formula.

Double posted: http://www.excelforum.com/excel-gene...ialog-box.html