Excel ActiveX Workbook VBProject Property

[DrNO23]

Hello All,

   I've created different LabVIEW VI's that import data from excel but I would like to create one that runs a macro (can't use the Report Generation Toolbox).  I have the basic code but I'm not sure how to access the VBProject property of the Workbook I'm referencing.  Does anyone know how I obtain this block?

[nyc_(is_out_of_here)]

---

@DrNO23 wrote:

Hello All,

   I've created different LabVIEW VI's that import data from excel but I would like to create one that runs a macro (can't use the Report Generation Toolbox).  I have the basic code but I'm not sure how to access the VBProject property of the Workbook I'm referencing.  Does anyone know how I obtain this block?

---

Learn how to translate VBA to LabVIEW.  https://support.microsoft.com/en-us/kb/194611

[DrNO23]

nyc,

   I'm not exactly sure what you mean.  The point of writting this VI is so that I can vary a couple of parameters and then translate that into a macro which will completely format an Excel Workbook for me but I just can't seem to find the 'Workbook' object that has the VBProject property listed under it.  

[nyc_(is_out_of_here) · Accepted solution]

---

@DrNO23 wrote:

nyc,

   I'm not exactly sure what you mean.  The point of writting this VI is so that I can vary a couple of parameters and then translate that into a macro which will completely format an Excel Workbook for me but I just can't seem to find the 'Workbook' object that has the VBProject property listed under it.  

---

Post your VI.

The fact that you cannot find the VBProject property indicates an error in your code.

You need to know understand the Excel Object Model to program it in LabVIEW.

[DrNO23]

nyc,

   I see what you're saying.  I've learned how to use ActiveX by basically taking the property and invoke nodes from other VI's I've found and making it work the way I need it to.  My problem is that I can't find the Excel Application Object Library which will give me the propty and invoke blocks I need.  Do you know what that file name is or what the library is called under the "Type Libaray"

[nathand]

Try the Microsoft Excel object library; the version will vary depending on what version of Office you have installed. You probably want to open a reference to the Application object, then use invoke and property nodes from there to get a reference to a workbook.

[DrNO23 · Accepted solution]

I found the solution.  If you can't find the Excel Object Library under the dropdown of all the installed object libraries its becuase apparently the Excel team does it differently and compiles the library into the EXCEL.exe file.  Just bring up the "Select Object from Type Library" window and then 'browse' and find the EXCEL.exe file.  It will incorporate it like the .OLB files

[nyc_(is_out_of_here)]

---

@DrNO23 wrote:

I found the solution.  If you can't find the Excel Object Library under the dropdown of all the installed object libraries its becuase apparently the Excel team does it differently and compiles the library into the EXCEL.exe file.  Just bring up the "Select Object from Type Library" window and then 'browse' and find the EXCEL.exe file.  It will incorporate it like the .OLB files

---

Why don't you post a VI instead of talking about it?  It would so much more helpful.  I have no clue what you just wrote there in your explanation. Yes, call me clueless.

In addition, which version of Excel would be helpful as well.

[DrNO23]

nyc,

   I just wanted to know how to get the block that I showed in the question, the "VBProject property of the Workbook I'm referencing", thats why I only showed the one block.

When working with ActiveX and Excel, you need a Library of the functions and properties which you can modify to manipulate the EXCEL sheet.  To get started you can first use a Reference to your library and then feed that into the Property and Invoke nodes which allow you to write the variables from LabVIEW.  My problem was that I couldn't find the location of the file to point my Automation Refnum control at.  If you wanted to mess around with Microsoft PowerPoint then you simply right click your Automation Refnum "Select ActiveX Class">>"Browse" and then scroll through the lists of Object Libraries and if you can't find it then you can select "Browse" on that window and search the Microsoft Office folders for MSPPT.olb, the file that will give you access to PowerPoint control through LabVIEW.  If you wanted to manipulate Excel files in LabVIEW you would need to find the EXCEL.exe executable through the Select Object window and voila you now have ActiveX control of EXCEL.

[nyc_(is_out_of_here)]

---

@DrNO23 wrote:

nyc,

   I just wanted to know how to get the block that I showed in the question, the "VBProject property of the Workbook I'm referencing", thats why I only showed the one block.

When working with ActiveX and Excel, you need a Library of the functions and properties which you can modify to manipulate the EXCEL sheet.  To get started you can first use a Reference to your library and then feed that into the Property and Invoke nodes which allow you to write the variables from LabVIEW.  My problem was that I couldn't find the location of the file to point my Automation Refnum control at.  If you wanted to mess around with Microsoft PowerPoint then you simply right click your Automation Refnum "Select ActiveX Class">>"Browse" and then scroll through the lists of Object Libraries and if you can't find it then you can select "Browse" on that window and search the Microsoft Office folders for MSPPT.olb, the file that will give you access to PowerPoint control through LabVIEW.  If you wanted to manipulate Excel files in LabVIEW you would need to find the EXCEL.exe executable through the Select Object window and voila you now have ActiveX control of EXCEL.

---

I am familiar with Accessing an ActiveX-Enabled Application as outlined at http://zone.ni.com/reference/en-XX/help/371361H-01/lvconcepts/using_activex_with_labview/

I don't understand what YOU are doing. So I am simply asking for a VI.