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)"
|