Hi Alvin,
Sounds to me like you need to try and get back to a system that runs your
original setup, i.e. Excel 2000 & whatever OS you previously used.
I have some experience of ActiveX calls to Excel, but have not yet tested
old apps with the new version of Excel. My suspicion would be that it is
the Excel upgrade that has caused this issue. It also sounds like part of
the problem is that the file itself is not opening - can you set the ActiveX
property to 'visible' so that you can prove to yourself that the file is
correctly opening before going any further with your investigations?
Best wishes,
Chris Harden.
Test System Design Engineer.
> -----Original Message-----
> From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED] On
> Behalf Of [EMAIL PROTECTED]
> Sent: 18 March 2004 16:45
> To: [EMAIL PROTECTED]
> Subject: LabVIEW to Excel wierdness
>
>
>
>
>
> Dear Folks,
> I have a LabVIEW app that writes report data out to disk as a
> tab-delimited
> text file, then triggers an Excel macro. The excel macro is an auto-open
> macro, so I have a vi which opens the macro.xla file, then an ActiveX call
> from LV that tells Excel to run the auto-open macro. This has worked fine
> in the past, for previous projects, but on a recent project (in which I
> copied over the same vi's from the old project) I could not get it to
> work.
> Now labview opens the text file in excel, opens the macro.xla file, then
> instead of running the macro Excel just closes both files and nothing
> seems
> to happen. I tried several different things with timing, thinking maybe
> the
> text file wasn't completely open when the macro was triggered, or some
> such, but to no avail. I put a pop-up message box in the macro at the
> start, and that works, it pops up, but after I dismiss it I see the same
> behavior.
>
> This morning, I loaded my old app, and to my surprise it no longer worked
> either. The only change in Excel is I recently upgraded to Office XP, so
> now it is Excel 2002 vs maybe Excel 2000 before. I have had to fiddle with
> the ActiveX calls before for changes in Excel, but I tried all the usual
> fiddling (delete and redrop the invoke/property nodes, change the property
> to something else and back again, recompile the vi) made no difference.
> Does anyone else have any experience with this? I am really doing very
> little with ActiveX, just having Excel open a text file, open a macro
> file,
> and run the xlauto_open macro, then waiting until the number of open
> worksheets goes to 0 so I can close Excel.
>
> Thanks in advance,
> Alvin
>
> Alvin W. Moore Jr.
> Measurement Systems Programmer
> Research, Development, and Engineering
> Corning Cable Systems
> Hickory, NC
This e-mail and any files transmitted with it ("E-mail") is intended solely for the
addressee(s) and may contain confidential and/or legally privileged information. If
you are not the addressee(s), any disclosure, reproduction, copying, distribution or
other use of the E-mail is prohibited. If you have received this E-mail in error,
please delete it and notify the sender immediately via our switchboard or return
e-mail.
Neither the company nor any individual sending this E-mail accepts any liability in
respect of the content (including errors and omissions) and timeliness of the E-mail
which arise as a result of transmission. If verification is required, please request
a hard copy version
