Using Office.FileDialog, or alternative
Posted on 2004-08-16
Hi there Access Gurus,
I am wondering if it is possible to user the Office.FileDialog component with late binding. The reason for this is that the application is distributed to Access 2000 and XP users. If 2000 users hit the 'browse' button, then I will just flash an error message saying "this don't work with 2k", when it kacks at the "createobject" line. If I use early binding, then it won't compile at all under 2k.
All the examples that I have run across use early binding, and the code below doesn't work.
Dim fDialog As Object
Set fDialog = CreateObject("Office.FileDialog")
Better yet, does anyone have a class module that I can plug in that will work on 2k or XP?