Hello,
Currently working on StatPlanet Desktop, I want to switch to StatPlanet CLoud Trial.
However when I want to import my excel data on the StatPlanet_Data_Manager, I encounter an error not present on the StatPlanet_data_editor for the same data. The error is : "RunTime error '1004' : Error defined by the application or by the object. "
The corresponding line of code for debugging is : "Set r2 = Workbooks(ReportFile).Sheets("Imported Data").Range(Workbooks(ReportFile).Sheets("Imported Data").Cells(1, foundColumn), Workbooks(ReportFile).Sheets("Imported Data").Cells(totalRows, foundColumn))".
How can I correct this problem ?
Regards,
Enola.
Hi Enola,
Two potential possibilities could be:
- Issue with the data structure, see if the file you are importing has a similar structure to this: (it can detect different structures but a template example can be useful to adhere to)
https://www.statsilk.com/files/resources/data_example_for_import_worldma...
- When you import, try not to switch to other tabs but keep it running while importing. Switching to another tab or doing other tasks can interrupt the import process.
I hope it might be one of these,
Best regards,
StatSilk
Hello,
Thank you for your response, however I have not been able to resolve the issue. So I sent you my files by email.
Regards,
Enola
Hi Enola,
Thanks, will take a look at this and let you know what the issue is.
Best regards,
StatSilk