append variable to file path???

[mushynator]

Hi, I am new to vba. This probably isn't hard at all for lot of you, but here is my problem.
I have the user input a name, then I add (using & sign) more characters to that name to make it a "fully qualified" file name. I then store the whole thing in a variable, let us say myFileName.
Next, I want to open this file, but I am not sure how to refer to a variable when using something like:
Workbooks.Open Filename:="C:\dir\myFileName"
Could someone please help?

Thanks

[Bob Phillips]

Something like this

[vba]


Dim mpFilename As String
Dim mpFullname As String

mpFilename = InputBox("Supply a filename")
If mpFilename <> "" Then

mpFullname = "C:\dir\" & mpFilename

Workbooks.Open filname:=mpFullname

'etc
End If
[/vba]

but personally, I would use GetOpenFilename to throw up a dialog and let them navigate to the file to open. GetOpenFilename returns the selected path and filename, so you still have to open it.

[mushynator]

AWESOME!!!
This worked perfectly. Thanks a lot!!!