Pull data from workbook with variable name - based on date

Ok, here's another one I'm trying to figure out....

I'm trying to pull all data from an outside workbook with a name that changes based on the date that is hosted on our companies internal sharepoint site.

So far I've been able to create a string that when the value is output to a cell is in the correct format. All the user has to do is enter the date for the file they want.

Please Login or Register  to view this content.

I have not however been able to pull data from the workbook that is stored at that location using that string.

Please Login or Register  to view this content.

I'm most likely doing something stupid... Any ideas?