Hi guys,

I have a sheet which is feeding in market prices from another workbook. It has bond names in col A and vlookup of prices based on those names in col B. The prices are pulled in from a file which is generated daily (since prices are updated daily). So, today, the external file would be called file_20050606.xls. I need vlookup to find today's file every day and pull the prices from there. I've tried creating a volatile filename path using TODAY() and then using INDIRECT to point to the cell with that file path but...it doesn't work with closed worksheets. And INDIRECT.EXT won't help either because it doesn't work with ranges, making it useless within VLOOKUPs

I've searched around and found that Harlan Grove wrote a pull() function which does what I'm trying to do. I've pasted it into a new module in my VBA, but when I write 
Please Login or Register  to view this content.
All I get are #VALUE in all the vlooked-up cells

Am I using incorrect syntax?

By the way, the contents of MacroSheet!C5 are: 
Please Login or Register  to view this content.
The UDF code for PULL() is: 

Please Login or Register  to view this content.
I was also wondering if I could use this function with cell names? Sort of like =vlookup(B2, pull(CellName),3,FALSE) instead of specifying the cell's location.

Thanks so much for any help!