| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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)" |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Define variable from cell to open a file | Excel Programming | |||
| How to define variable | Excel Programming | |||
| open file (as variable) from macro | Excel Discussion (Misc queries) | |||
| Syntax to define a variable for current file | Excel Programming | |||
| Using a variable name as part of a file pathname to open many files | Excel Programming | |||
Threaded Mode
