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,
Holly
Hi Holly,
Sorry to hear about this. Which version of Excel for Mac are you using?
A new version will be released soon, aiming to resolve the issues with Excel for Mac.
Best,
Frank
I am using excel for Mac 2011 version 14.3.9
Many thanks, I am looking into it.
Best,
Frank
Hi,
The cause has been found - it can be resolved by preceding the line where the debug stops ("ActiveWorkbook.close") with the following line:
Unload ProgressBar
This will lead to a lot of screen flickering while it imports, but it should work. The StatPlanet Data Editor will be updated in the next version of StatPlanet / StatTrends.
Best,
Frank