Last line in excel using MS-report toolkit?

[Mr.Me]

I'm using the MS report toolkit and am trying to find the last cell in an excel report to import data into Labview so I can both manipulate data and create plots from the retrieved information. How is this done?
I would also like to search for the last row/column to add more data to an exsisting sheet instead of inserting it to the top of the sheet.

[Jimmie_A.]

Hello!

Sorry for the delay, but here you have an example program that do what you asked for! Not using Report Generation Toolkit, just pure ActiveX calls. I attached a Excel workbook so you can test the functionality.

Cheers,
Jimmie A.
Applications Engineer
National Instruments Sweden AB

[Wiebe@CARYA]

But do close the "workbook" and "range" references, or you'll get memory
leaks.


"jimmie-a" wrote in message
news:506500000005000000AE710100-1079395200000@exchange.ni.com...
> Hello!
>
> Sorry for the delay, but here you have an example program that do what
> you asked for! Not using Report Generation Toolkit, just pure ActiveX
> calls. I attached a Excel workbook so you can test the functionality.
>
> Cheers,
> Jimmie A.
> Applications Engineer
> National Instruments Sweden AB