Refrence a workbook by custom path

[Justair07]

Hello everyone,

I need to reference a workbook from a formula, for example:

='[Daily Shipment Report 4_21_2014_DAVID.xls]WorkSheet'!$A$93

But instead of the formula always having the full path I want it to look for the path with the date before today. For example I places this in a separate cell (S11):

=today() - 1

I want to use this date to complete the path for the workbook being referenced.

Here is what I tried but failed:

='[Daily Shipment Report & S11 & _DAVID.xls]WorkSheet'!$A$93

Thank you for the help,

- Justin

[zmbd]

I know that someone is going to just give you the answer; however, I don't see how that will help you in the future so I'll point you in the right direction here...

Take a VERY carefull look at this:
='[Daily Shipment Report & S11 & _DAVID.xls]WorkSheet'!$A$9 3
Note your single quotes and the placement of your concate (the ampersands)?! These are not entirely correct, close but not quite right. (^_^)
Note the VERY end of your string equation... what are you missing between the square bracket and the "W"

Now you are going to have to deal with the spaces in the file path and name... that sucks, and is why one shouldn't use spaces, special characters, reserved words or tokens, and only use underscores and the alphanumeric set.

in trouble shooting... did you attempt to see how the string was/is actually resolving?