Please help...This is turning into a nightmare
Posted by Justin on November 08, 2001 1:33 AM
I am creating a database of infomation files that have been created using a purpose built excel 97 template. In order to do this I output a directory list, where all the files are, to a text file- call the file into column A in excel and run the following formula next to it
Root = C:\x
File = abc.xls [from directory list]
Cell reference = Payrate
Linking Formula = =""&"="&"'"&root&"\"&file&"'"&"!"&cell reference
The result is ""='c:\x\abc.xls'!payrate. I then run a replace command to find ""=' and replace it with ='c.
Two problems concern me with this method.
1. there must be an easier way...HELP (there are 4000 files to pull, 10 different cell references on each)
2. If there isn't an easier way, how do I turn off the 'dead link' message when a file is corrupted or does not have that reference. This is what slows my method down