open spreadsheet via inputbox

[mash100]

can anyone tell me how to open a certain spreadsheet by typing the filname into an inputbox?

Thanks in advance!

 

[SkipVought]

Why go to all the trouble of typing?

Check out the GetOpenFileName method of the application object.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[mash100]

Thanks for the reply Skip, im wanting to do some VBA work on a certain spreadsheet that the user will know the filename of without having to browse through the files as there may be many.

thanks.

 

[SkipVought]

Believe me; I know my filenames, too, but I NEVER type a filename for an existing file, cuz you ALSO need to type in the entire path as well!!!

But here's a keyboard-intensive example, and I'd be cursing the coder...

    Dim FName
    FName = InputBox("Enter File Path\name")
    If FName <> "" Then
        Workbooks.Open FName
    Else
        MsgBox "Can"
    End If

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[mash100]

Thanks Skip, much appreciated.

mash100