ActiveX Topic: REFNUM Connection

[dp_wave]

Hello,

Please find attached a snapshot of VI (sorry, I don’t have the tools for PNG file type).

I would like to connect the “Open/Create/Replace File” VI REFNUM reference to the property node “Worksheet” REFNUM reference. Is there some relatively simplistic code to implement between both REFNUMs in order that the VI is executionable when connected?

Thank you for your time!

[Matthew_Kelton]

It is much more complicated than that.  A file refnum is not compatible with an Excel Worksheet ActiveX reference.

See the attached example as to how to get where you want.  Make sure you close all the ActiveX references that get open.  Below, there is an ActiveX reference for:

Excel Application
Workbooks
Workbook (the one opened)
Worksheets
Worksheet (the one specified)
Cells

Message Edited by Matthew Kelton on 10-11-2007 03:22 PM

[Wiebe@CARYA]

>
> Please find attached a snapshot of VI (sorry, I don?t have the tools for
PNG file type).
>

You don't have Paint?? Btw. .bmp or .jpg also works fine!

Regards,

Wiebe.

[dp_wave]

Thanks for your response Matthew K,

I have implemented something very similar to what you propose prior to my post. My objective was to try and re-use the “Open/Create/Replace File” VI, which initially creates and opens the file, since this is the function/VI I use in my application. My top-level application requires that I dump data in a “real-time” manner on an iterative process (via a For Loop). So instinctively, I would like to create and open the XL file during the first iteration (i = 0) only, and dump data into the referenced file for the remaining iterations without having to open the file for each go around loop. I’m having some difficulties in re-referencing that XL file (via REFNUM) without having to re-open the file for each data dump iteration. As you mention, it’s more complicated than what might appear at first glance.

[dp_wave]

Wiebe@CAR...,

I do have Paint but the version I have does not support PNG type files...but yes it does support bmp type. In the future I can attach a file in jpg or bmp format if easier for everybody....thanks!