Thank you for your reply.
I missed out an important aspect...I am using (i.e. stuck with) Access 2000. It is my understanding that the File Dialog object was not implemented until Access 2007. As far as I have been able to find, I am stuck with using the code above...
I am currently working on a database that uses the Windows API to call an open dialog box to allow the user to select an Excel file, which I then import into the database. Currently, the user has to select one file at a time (which is working perfectly); however, they may receive anywhere from 8...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.