I am having the same issue as Barbara had earlier posted:
My first problem was when I clicked Import data I received a Run Time Error 1004 stating " DataFile = Application.GetOpenFilename("All files (*.*), *.*", , "Please select a file to import")" . I changed this to "datafile=application.getopenfilename()" and then tried importing the data again. However, now, it loads a little bit and says Run Time Error 1004 "excel cannot find the matching data to replace. No cell selection contains what you typed, or no records match the criteria.
I have tried uploading the sample dataset provided in the zip file and the same error comes up.
The highlighted code for this message is: ActiveWorkbook.close savechanges:=False on Line 742 Column 15.
Any help would be beneficial! Thank you,