Initialising Referencing Paths
In cell A2 I have a value/filename (which I created by having code grab all
file names in a folder). I now need to use this value/file name to suck data out of the files in this folder without having to open every file to get an initial link. Somehow, I can't get the examples of the formulas below to work. How can I get directory path presented simply as text to become an active link that can be pasted into formulas without creating a hyperlink from each - there are 3000 files. EG Value/File Name In A2 C:\Desktop\Product1.xls In B2 I need to pick cell information within this file. ='[A2]$B$2 In C3 I need to pick cell information within this file. ='[A3]$B$3 Thanks in advance... |
Initialising Referencing Paths
Hi Gordon
Use INDIRECT function Thanks Xcelion "Gordon" wrote: In cell A2 I have a value/filename (which I created by having code grab all file names in a folder). I now need to use this value/file name to suck data out of the files in this folder without having to open every file to get an initial link. Somehow, I can't get the examples of the formulas below to work. How can I get directory path presented simply as text to become an active link that can be pasted into formulas without creating a hyperlink from each - there are 3000 files. EG Value/File Name In A2 C:\Desktop\Product1.xls In B2 I need to pick cell information within this file. ='[A2]$B$2 In C3 I need to pick cell information within this file. ='[A3]$B$3 Thanks in advance... |
Initialising Referencing Paths
Laurent Longre has a utility called MOREFUNC which provides a INDIRECT.EXT
UDF which should do what you want, and you can find it at http://xcell05.free.fr/ -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Gordon" wrote in message ... In cell A2 I have a value/filename (which I created by having code grab all file names in a folder). I now need to use this value/file name to suck data out of the files in this folder without having to open every file to get an initial link. Somehow, I can't get the examples of the formulas below to work. How can I get directory path presented simply as text to become an active link that can be pasted into formulas without creating a hyperlink from each - there are 3000 files. EG Value/File Name In A2 C:\Desktop\Product1.xls In B2 I need to pick cell information within this file. ='[A2]$B$2 In C3 I need to pick cell information within this file. ='[A3]$B$3 Thanks in advance... |
All times are GMT +1. The time now is 01:52 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com