Open Dialog Box
Posted by Ron on June 06, 2001 6:22 AM
I'm sure I'm just overlooking something, but I would like to have a command button that will open another excel file. I would like the Open Dialog box to open to a specific directory. I've started with the following code but am not sure how to open to the folder C:\Testing , and open the file the user chooses.
Thanks for any advice!
Private Sub cmdOpen_Click()
fileToOpen = Application.GetOpenFilename("Excel Files (*.xls), *.xls")