LabVIEW and excel activex question

[GHernandez]

Hey Everyone,

I got LabVIEW to open an excel file and to resize the columns. I'd like to save the changes and close the file. I tried wiring a boolean true constant and converting it to a variant, unfortunately it is not in the format it expects it because the file remains opened and i get an unknown error. I've attached the Vi (LabVIEW 8.20).. and a screenshot.

Hopefully it makes sense,

thank you all.

[smercurio_fc]

You just need to wire a boolean constant directly to that input. Since it's a variant input it will accept that datatype directly. However, since you're explicitly saving the file you shouldn't need to wire anything.

Also, you can eliminate two of your steps. The "Open" method returns to you the workbook reference, so you do not need to Range's Application property and then the "ThisWorkbook" property. Wire from the "Open" method directly to the "Save" method:


Also, you need to close the reference to the objects that get created. This should be done in the reverse order that you opened them.

Message Edited by smercurio_fc on 07-30-2007 11:07 AM