opening a folder from worksheet

Morning all,

Is it possible to have a text box and a macro button that when a user enters a name of a folder (or part of the name) on say the c:\ drive it takes you there?

Example being i have a folder called Alcan Inc on my c:\ drive, so i type in the text box alcan and click the macro. it then opens a windows explorer screen with the folder open.

Any ideas would be great!

Re: opening a folder from worksheet

Bob,

Thanks for that but (always a but :)) his works for when I have the whole name of the folder i.e. alcan inc.

Is it possible that I enter say alcan and it opens the alcan inc folder?

Thanks in advance