B
Bob Barnes
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
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