I am writing a Macro in Excel where in there is a reqirement of Common Dialog box control.

On clicking of Browse button(Command Button)...user should be able to see the Windows explorer diaglog box to select a file located anywhere on his M/C.

Once user select this file,I need to get that full path from dialog box as a String and use this String in my code.

I couldn't find a Common Dialog Box control in Excel Macro VB editor in Additional Controls of Tool Box.

Can somebody help me on this.