I I need a File Open routine that will work on Access 2007 32 bit and 2010/2013 64 bit in a similar fashion to Excel:
FileName = Application.GetOpenFilename(fileFilter:="Excel Files (*.xls), *.xls")
I have been using code originally courtesy of: ' Microsoft Access 95 How-To ' Ken Getz and Paul Litwin ' Waite Group Press, 1996 ' Revised to support multiple files: ' 28 December 2007, but that won't work on a 64 bit system.
Can anyone suggest a way of doing it? I was once told I could use the excel function by creating a reference to Excel but I am not sure how to do that.