Excel ActiveX: Count Rows

[esa_paranoid]

Hi, I am trying to simply count the used rows in an excel spreadsheet (which I have done in the past).

Attached is a simple vi which I am trying to get to work.  On my development PC, this works fine, counts the rows etc...on this PC I have Excel 2003.

When I create an EXE out of this VI and put it on another PC with Excel 2000, it returns "0" for the number of used rows.

Can ANYONE help me here, this is driving me insane.

Working in 7.1 (can use 7.0 or 8.0 if it makes it easier)

Thanks,

Ryan

[Albert.Geven]

depending on the version of excel you have a slightly changed activeX (nice from MS).

so you have to build an executable for the correct LabVIEW Excel combination.

[esa_paranoid]

ok so what exactly are you saying?

should i try building an executable from 7.0 or what?

[Dennis_Knutson]

As Albert said, it is the change between versions of Excel that are the problem and nothing to do with LabVIEW. You would have to rewrite your application (in any LabVIEW version you want), with the different version of Excel installed and use the different methods and properties that are in that version of Excel.

[esa_paranoid]

So, in order to use an exe utilizing ActiveX, all PCs that you plan to put the exe on must have the same version of ActiveX/excel????

That seems fairly limiting....

eeesh!

I'll give it a shot....thanks for the help!

[Dennis_Knutson]

It is limiting but I place the biggest blame on Microsoft for changing the properties and methods so much between different releases. You could put all of your Excel functions in a library that you call dynamically. That way, you don't have to re-build the exe but just distribute the library specific to whatever version of Excel you need to support. Unless you really need some specific Excel formatting, you could also save to comma/tab delimited text files. All versions of Excel can open them and you won't have to make a career out of modifying your application for as long as Excel is going to be around.

[Brian_Beal]

You can query the version of Excel that is on the computer.  Then use the ActiveX components for that version.  You can only do this with LV 8.0 because the other ActiveX calls must be disabled, not just not used.