【转帖】common dialog
 

common dialog
hi all,
just wondering if someone can help me. i want to create a common dialog where i can browse for particular file formats. i am adding some additional flexibility to a macro so i can browse to a folder and select a file of a specific type (ini and mdb)once the file is selected the filepath of the selected file will be shown in a textbox.
i will be upgrading this macro over the next few weeks to vb.net but for the moment i need to get it working in vba.
how can i best do this?
thanks,
declan.
declan,
right mouse on the grey area "controls" tab of your vba "toolbox" dialog box and "additional controls". select "microsoft common dialog control" from the list of controls.
wayne matus
texas engineering systems