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

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

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
>