If the WB is not open, the normal way of dealing with data is ADO. Depends
on the structure of the data.

NickHK

"okrob" wrote in message
oups.com...
On Mar 21, 4:37 pm, Gleam wrote:
s1= [data1].Address



"okrob" wrote:
How can I create a string variable from a named range in a workbook?

ex:

Named range is at address: $D$11:$AB$11
Name is: data1
String I want passed into a variable is: "D11:AB11" or "$D$11:$AB$11"

Thanks
Rob- Hide quoted text -

- Show quoted text -

OK, Blonde moment...!!!
I forgot to mention that the range is in an unopened workbook...