use common dialog box

[pleb]

Hi,

I want to use common dialog to choose a file.
To day I use GetOpenFileName with an Excel Objet in VBA Project : It is
"durty"

I don't want to create an excel object, I want to use windows common dialog
off the system.

solution 1 : enable the reference of the common dialog DLL
But I don't find in "reference VBAProject" box, the reference to use

solution 2 : declare the API Public Function OpenFileDialog(lngFormHwnd As
Long, ....
I think it is not enough simple....


Is there someone has already the common dialog box in VBA in project ?
PLEB

 

[Rod Gill]

Hi,

Visit www.mvps.org/access

Go to the Win32 API page and look at their file open dialog code. I've used
it before and it has worked unchanged in Project.