Creating a button to open a specific folder in my documents

[rob nobel]

I would like to know if there is a way to have a macro go to the Open
Document procedure but go to a specific folder.
I've tried this with a macro but it doesn't record anything unless I
actually open a file in that folder. I just want it to go to the folder so
I can select a file myself.
Rob

 

[Dave Peterson]

Something like this:

Option Explicit
Sub testme()

Dim myFolder As String

myFolder = "C:\my documents\excel\test"

ChDrive myFolder
ChDir myFolder

Application.Dialogs(xlDialogOpen).Show

End Sub

 

[rob nobel]

That's GREAT!!
Thanks Dave
Rob

Something like this:

Option Explicit
Sub testme()

Dim myFolder As String

myFolder = "C:\my documents\excel\test"

ChDrive myFolder
ChDir myFolder

Application.Dialogs(xlDialogOpen).Show

End Sub