Automation 2-Part Question...
 

I'm using Access 2003 to Excel 2003.

I identify a string like "Mar06" as part of an xls
Filename where the automation from Access is going.

When I automate that value of "Mar06" it is placed in the
Excel Named Range "TheFile" as a date, rather than a string.
That's the first question - how to store that data as a string
from automation.

Second question, I'd like to use that string like old
Lotus 1-2-3...@Cell("contents") as a variable here...

Dim V As Variant
V = TheFile....that's the string I want, the...
Application.Goto Reference:=V
....where I copy a Named Range.

TIA - Bob