VBA HELP Command button

[CodesiriuS]

Hello - Im new to VBA and Im trying to make a userform that has a button that pretty much launches the window explorer but then lets the user navigate through the directory and upon selecting a file - also opens it so they can utilize other macros to format it. I have this so far but I don't know the code to open the file

Private Sub CommandButton1_Click()
ThisWorkbook.FollowHyperlink "file:\\c:"
End Sub

 

[BQardi]

Just add the path and filename:

Private Sub CommandButton1_Click()
ThisWorkbook.FollowHyperlink "file:\\c:\path\file.txt"
End Sub

EDIT: Nevermind, I was a little to quick to post without really reading your question...

 

[BQardi]

Maybe this:
Excel Open Dialog Box

 

[CodesiriuS]

Thanks BQardi!! This code upon button click will allow the users to search through the directory and open a file however, upon opening the selected workbook the selected file freezes up and wont let me close out of it. I'm trying to figure out if I should purse trying to troubleshoot this or just make the form to where the user clicks the button to get the file, and then once the file is selected the path shows up in an adjacent text box or something.Then the user can check what formatting options they want, then hit a processing button and be done with it. I have used other utilities like this but I'm green and still don't know what best practice is or in my case easier to start with. Any help or direction would be appreciated.

 

[BQardi]

You're welcome

As far as I understand, you are trying to change formatting of other workbooks, from this main workbook?

This is advanced in it self and probably harder when using userforms for this task (userforms lockup Excel until closed and this is probably the issue you are experiencing when trying to open another workbook).
I would recommend NOT using userforms for tasks like this when you are, as you said, "green"...

 

[Norie]

If you want the user to chose a file then why not use Application.GetOpenFilename?

 

[CodesiriuS]

Thanks! Maybe I should tackle from a different angle.

 

[CodesiriuS]

HI Norie that code didn't open the file

 

[Norie]

It will get you the filename of the workbook the code has selected which you can then open using Workbooks.Open.

 

[mikerickson]

This will allow the user to browse and open the file, but the name has to be extracted after its open

If Application.Dialogs(xlDialogOpen).Show Then
    MsgBox "The newly opened file is " & ActiveWorkbook.Name
Else
    MsgBox "User canceled"
End If