Hi Dave,
I understand that you're using the BuiltInDocumentProperties property of a workbook and unable to access the data. Technically, this is more of a microsoft/visual basic issue than a LabVIEW (LV) issue.
Even so, using the variant to data VI is the right way to get the builtInDocumentProperties of the excel workbook. The key is to specify the correct data type for the variant to data VI. The best source to find this data type is in the Microsoft Visual Basic Help files which you can access within Excel under Tools >> Macro >> Visual Basic Editor.
If you look in the help file, you will find that builtInDocumentProperties returns a collection of Document Property Objects. The first step to access the document property object is to feed in a workbook referen
ce as the data type for the variant to data type VI. After you provide the correct data type, you will be able to create a property node to get each item from the collection of document property objects. In this case, the item is a document property. Once you have the item, you can create a property node to get the value of the item.
I recommend trying to access the workbook properties in this manner. There are several resources which will help in this task:
1. Visual Basic Help will provide descriptions of the excel data types as well as example macro programs which you can use to model your LV code.
2. The Microsoft Developer Network (MSDN) may have useful information.
3. If you search for the functions in Google, you may find examples that better relate to what you're trying to do.
If none of these resources help, and you are still unable to implement your LV code, you can post a simplified version of your code along with a description of the errors (including numbers) that y
ou are getting.
Hope this helps!
Marcus G.
National Instruments