In article <2f923b03.0e5dba3b@usw-ex0109-
070.remarq.com>,
Gorka Larrea wrote:
> I'd like to control Excel from LabVIEW, and
have started
> using ActiveX. But the only thing I have done
is open
> Excel, create a workbook and add worksheets.
Has anybody
> got any examples or information I've missed?
I'm not able
> to insert data from an array, or use the save as
> property... Is ActiveX allways so complicated?
> Thanks in advance and best regards.
>
> Gorka Larrea
> glarrea_1@hotmail.com
>
> * Sent from AltaVista http://www.altavista.com
Where you can also find related Web Pages,
Images, Audios, Videos, News, and Shopping.
Smart is Beautiful
>
I faced the same task a year ago. My solution was
to record a macro while I manually f
ormatted a
dummy file called template.xls.
I used the EXCEL-macro example that I downloaded
from NI's website and modified it for my needs.
Using Active-X, I opened the XL file I wanted to
format and ran the macro. My measurement table
looked just like the template file.
Once you have a macro, you can modify it using
the Visual Basic Editor in EXCEL.I know exactly
the pain you are experiencing!
Gabe
Sent via Deja.com http://www.deja.com/
Before you buy.
