Add-in crashing when attempting to import data from Excel

[ABM]

Hi,

I created an add-in within Eviews that imports data from excel. It utilises the following command

import(type=excelxml, c=max) %dir range=%shtRng @id {%id}

And then a reference table with the directory,range and ID required to import the required data, e.g. if you have x data sources there are x lines of the table that the code will run through . I'm new to programming, not sure if it's common practice to post the whole code, happy to do so if needs be.

Eviews will usually crash if I am trying to populate a new workfile with new variables and I attempt to run through several data sources, if I do the same exercise running the programme X times for each individual data source then it will not crash. If I then run the same programme in the same workfile now fully populated it will not crash no matter whether I run each line of the data import table individually or in one execution.

Hopefully you can help, thanks for your time.

Cheers,

Asher

[EViews Gareth]

I think we'll need to see some concrete examples. Could you post the workfile/program/Excel files?