Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
string variables in file names
Can i use a defined string variable in a file name when opening? if so what
is the appropriate syntax? example.... Workbooks.Open Filename:= _ "C:\Documents and Settings\HP_Owner\Desktop\PanelSelect\panels\16-1 letterO.xls" i want to use a string variable named "antfile" in place of the file name 16-1letterO.xls -- dr chuck |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
string variables in file names
Yep:
dim antfile as string antfile = "somestringhere" Workbooks.Open Filename:= _ "C:\Documents and Settings\HP_Owner\Desktop\PanelSelect\panels\" & antfile dr chuck wrote: Can i use a defined string variable in a file name when opening? if so what is the appropriate syntax? example.... Workbooks.Open Filename:= _ "C:\Documents and Settings\HP_Owner\Desktop\PanelSelect\panels\16-1 letterO.xls" i want to use a string variable named "antfile" in place of the file name 16-1letterO.xls -- dr chuck -- Dave Peterson |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
string variables in file names
thanks for the syntax help dave.
-- dr chuck "Dave Peterson" wrote: Yep: dim antfile as string antfile = "somestringhere" Workbooks.Open Filename:= _ "C:\Documents and Settings\HP_Owner\Desktop\PanelSelect\panels\" & antfile dr chuck wrote: Can i use a defined string variable in a file name when opening? if so what is the appropriate syntax? example.... Workbooks.Open Filename:= _ "C:\Documents and Settings\HP_Owner\Desktop\PanelSelect\panels\16-1 letterO.xls" i want to use a string variable named "antfile" in place of the file name 16-1letterO.xls -- dr chuck -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
String variables | New Users to Excel | |||
Inserting variables within file names | Excel Worksheet Functions | |||
Parse String into Variables | Excel Programming | |||
String Variables | Excel Programming | |||
variables for file names | Excel Programming |