Define variable from cell to open a file
 

I have it calling B1

"Amir" wrote:

I am trying to open a file that has a date in its name. EX Data-20070816.csv

I have the user input the date in one cell (a1) and have a string formula in
another cell (b1).

I keep getting an error when I try to define the variable.


Windows("Data Comparison.xls").Activate
Application.Run "BLPLinkReset"
Sheets("Sheet1").Select

Dim Filename As String
Set Filename = Range("B1").Select

Workbooks.Open Filename:="V:\FTP Data\(Filename)"

Define variable from cell to open a file
 

It works now. Needed ( ).
Workbooks.Open Filename:="V:\FTP Data\" & (strFileName)

"Amir" wrote:

Yes the file exists. I have strFilename1X.

"Jim Thomlinson" wrote:

Where does the 1X come from. By prefixing FileName with "str" we get aound
the reserved word issue.

Does a file exist such as
V:\FTP Data\Data-20070816.csv

--
HTH...

Jim Thomlinson


"Amir" wrote:

It errors out at the Filename:="V:\FTP Date\" & strFileName1X



"Jim Thomlinson" wrote:

Try this...

Dim strFileName as String
strFileName = Range("B1").Value
Workbooks.Open Filename:="V:\FTP Data\" & strFileName

Note - Don't declare a variable FileName as that is a reserved word(ish).
--
HTH...

Jim Thomlinson


"Amir" wrote:

I have it calling B1

"Amir" wrote:

I am trying to open a file that has a date in its name. EX Data-20070816.csv

I have the user input the date in one cell (a1) and have a string formula in
another cell (b1).

I keep getting an error when I try to define the variable.


Windows("Data Comparison.xls").Activate
Application.Run "BLPLinkReset"
Sheets("Sheet1").Select

Dim Filename As String
Set Filename = Range("B1").Select

Workbooks.Open Filename:="V:\FTP Data\(Filename)"

Define variable from cell to open a file
 

It errors out at the Filename:="V:\FTP Date\" & strFileName1X



"Jim Thomlinson" wrote:

Try this...

Dim strFileName as String
strFileName = Range("B1").Value
Workbooks.Open Filename:="V:\FTP Data\" & strFileName

Note - Don't declare a variable FileName as that is a reserved word(ish).
--
HTH...

Jim Thomlinson


"Amir" wrote:

I have it calling B1

"Amir" wrote:

I am trying to open a file that has a date in its name. EX Data-20070816.csv

I have the user input the date in one cell (a1) and have a string formula in
another cell (b1).

I keep getting an error when I try to define the variable.


Windows("Data Comparison.xls").Activate
Application.Run "BLPLinkReset"
Sheets("Sheet1").Select

Dim Filename As String
Set Filename = Range("B1").Select

Workbooks.Open Filename:="V:\FTP Data\(Filename)"