Execution error in Macro

Kaps

Forums

Hi All,
When i am running a saved macro , i get the below error mesaage. 
"Running: Import Microsoft Excel
Execution error: Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index"
I tried to recreate the macro, but got the same error message. I  noticed in the Project Overview window, there were many deleted database and other records which i would have deletd while carrying the data analysis.
I thought the error is appearing because of these deleted records, so i did not select them when i created the Macro again, but got the same error message
Just was wondering, is the error coming because some records or database were deleted while carrying out the analysis
Please suggest
 
 

Brian Element Tue, 02/20/2018 - 04:59

Hi Kaps and welcome to the site.

When you received the error did it give you a line number?  Usually that helps tell which line of code is incorrect.

Also any chance you can post the code that is giving you the error or attach it, be a bit easier to help you out.

Thanks

Brian

Kaps Thu, 02/22/2018 - 04:43

Hi Brian,
I have created this Macro using Visual script option in Idea. The error message does not through any line number.
Since i have created the Macro using Visual script , i dont see any code getting created for the same
Sometimes with only limited number of analysis i.e. eirther 2 or 3, the Macro runs successsfully, but when there are multiple analysis being done, it does give me the same error message.
Is it hapening becauses of the deleted databases ? or something else
Please suggest
Regards,
Kaps

Brian Element Thu, 02/22/2018 - 07:12

Hi Kaps,

It is hard for me to say.  I usually just use IDEAScript, I never used Visual script that much.  Also I am not sure what you mean by multiple analysis.

Brian