Open a file with a name that changes according to value of a Name in VBA

Hi everyone,

This is my first post, so please bear with me!!!

I have two files, one called 'final.xls' and one called 'source 08-09.xls'. I want to define the name of 'source 08-09.xls' according to dates that users input in specific cells in 'final.xls', which I have defined as "yearfrom" and "yearto".

Here is what I've done so far, I can't seem to extract the actual value '08' and '09' from the defined name ranges:

Please Login or Register  to view this content.

... etc. Right now when I roll over the variables while stepping through the code, they look like this:

A = "=Suppliers!$T$19"
B = "=Suppliers!$T$20"
C = "source =Suppliers!$T$19-=Suppliers!$T$20.xls"

And I want C to look like = "source 08-09.xls"


I would appreciate any help! Thanks very much,

Candice

If anyone is interested, I figured it out myself:

Please Login or Register  to view this content.

... etc.