File Open

[mjmoon]

This site has been very usefull, thank you to all who have posted.

I am in need of help writing a macro to open a specific directory for the user to select any file they want. Basically, I want the user to click a button that gives them the same feature as file open on the toolbar. I have all toolbars turned off in this particular application thus the reason for this question.

Thank you in advance.

Marc

 

[Nimrod]

Public Sub showdemo()
Application.Dialogs(xlDialogOpen).Show ("c:\")
End Sub

Replace the ("c:\") with any valid path

Her's some extra reading for you
http://support.microsoft.com/?kbid=139723