Labview and Excel

[keeswe@my-deja.com]

I want to read a Excel Spreadsheet into Labview without having any idea
how big the spreadsheet is.
I know the 'LastCell' variable in VBA, but can't get it working in
labview using this varible in the 'special cel' method.

Can anyone help me?


Sent via Deja.com http://www.deja.com/
Before you buy.

[Vincent Hottier]

>I know the 'LastCell' variable in VBA, but can't get it working in
>labview using this varible in the 'special cel' method.


You should use "UsedRange". In my Version of Excel, LastCell doesn't exist.

[mulud]

Vincent Hottier wrote:
>>I know the 'LastCell' variable in VBA, but can't get it working in>>labview
using this varible in the 'special cel' method.>>>You should use "UsedRange".
In my Version of Excel, LastCell doesn't exist.>>>

Hi,
The easiest fix is to place key words (you'll need 3) on the borders of
your data
then search for them and then parse your Sheet. This saves a lot of headaches
without having to get fancy with VB