\'Invalid Index\' error when calling data
I'm getting the above error when trying to access data in an excel database.
The document is in a folder on the desktop of my computer, it is not being used by anyone but the program. When I check the activedata the status is 'OK'.
Once I run the script and get to the above point, I check back in the active data and the status is 'Read Only' yet I have not touched the document and no-one else can access it either.
Anyone got an idea how to combat this?
Re: \'Invalid Index\' error when calling data
Invalid index usually means that you are trying to access a data item at a point that does not exist in the file. The document status shouldn't really have anything to do with the error message, but you could open the document manually with Excel and change it to a shared document. This will allow multiple users to open the document and make changes at the same time.
To troubleshoot the index problem you need to determine the location at which the index error occurs in the document and then verify that data exists within the document at that location. In other words, verify the row and collumn that TP is trying to read and then verify it in the document.