excel program error 97 HELP

[Norbert_B]

Have you also reworked the previously called Excel VIs to match this pattern of opening/closing as well?

Have you also checked if "String 2" and "Select Range2" do have proper content? As already mentioned, i encountered the same error when "String 2" was empty....

Norbert

[Gak]

Hi Alan4,

Can you post your updated code (With password) ?

I opened Excel sheet from Zip file, there are many sheets, graphs as well..Can you tell us what sheet no you are reading?

If searched on NI.com (Error:-2146827284) it is related to graph.

[Gak]

Hi Alan4,

Two possibilities,

1)

2) may be  your data is not 2D...but here your Data to variant is trying to convert variant data to 2D. So error is coming.

I will explain how it is, if you are reading say A1:AU11, then it is 2D data. It will not give error. But if you are reading A1:A5 then it will give error as it is 1D data.

Did you get my point? That is why it gives error sometime not always. So your code was running fine say few days ago now it does not.

Your Vi in which you do some logic and come up with "Selected range" should be revised I guess. You need to work on it.

Also instead of reading excel many times, read it once it will give you less errors. You can read all sheet in one vi and have different array outputs contacting data corresponding to each sheet.

This will be simpler approach.

All the Best