Open folder not file

[advox1]

Hi

I have a button which when clicked needs to open a folder to show the workbooks contained in that folder.

The folder has a variable, so the folder path will look somehting like this

"P:\Spreadsheet Project\Testfolder\04_" & myVar"

Can anyone assist me with the code to open the folder only?

Thanks

Jo

 

[PHV]

As you want to show worbooks I guess you want an Excel tip.
Take a look at the Application.GetOpenFilename method.
Depending of your Office version you may also consider the Application.FileDialog object.

Hope This Help, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884