LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

.net error 1172 : excel open connection

Hi,

I have the labview program that open connection with excel work book. It was working all right for long time. Suddenly I am getting the error. I am not sure how to solve it>? I dont know anything about .net .So any help will be great.

 I have attache the code as well.

 

error_1172.PNG

 

Thanks,

 

0 Kudos
Message 1 of 6
(2,791 Views)

Does the Excel file still exist at the original location?

Did the version of Excel get upgraded to Excel 2007/2010/2013 ?

0 Kudos
Message 2 of 6
(2,760 Views)

Yeah the location is still there. I have excel version 10. I dont think I upgared excel.

 

You know, I ran the code with labview 2013. I see the error different now. It gives clue related to key . but I dont get it.

 

error_1172Q.PNG

0 Kudos
Message 3 of 6
(2,753 Views)

Some code would be helpful. Otherwise we're all just shooting in the dark.

0 Kudos
Message 4 of 6
(2,749 Views)

If you are using Excel 2010, then the connection string is wrong. It is meant for Excel 1997 to 2003.

0 Kudos
Message 5 of 6
(2,747 Views)

I did change the string  

Provider=Microsoft.ACE.OLEDB.12.0;Data Source=%s;Extended Properties=Excel 12.0 xml;

 

I still see the problem. I have attached my code.

0 Kudos
Message 6 of 6
(2,725 Views)