How to get the input from a combobox from a file like .txt oder .xls

[FatihEminSahin]

Hello,

I am a beginner in DIAdem. A will  know, how I can get the List Elements into a Combobox from a Textfile or an Excel File.

Please help me. Thanks a lot.

[Brad_Turpin]

Hi FatihEminSahin,

You're goinig to have to be a little more clear with your question.  What are these "List Elements" you speak of, and where do they come from?  Where is this "Combobox" you refer to-- are you wanting to build a Scriptable User Dialog (SUD) in DIAdem, perhaps?

You load data from Text or Excel data files into DIAdem using a DataPlugin.  Many standard file formats already have DataPlugins available for free download at www.ni.com/dataplugins.  If these are custom data files that you have defined, we'll need to create a DataPlugin for them.  You can either do that with the DataPlugin Wizard in the NAVIGATOR, or we could program the DataPlugin(s) from scratch in VBScript.

Brad Turpin

DIAdem Product Support Engineer

National Instruments

[FatihEminSahin]

Yes it will be a SUD Dialog in DIAdem. There gives comboboxes. I want that the input of the combobox (wich are chooseable by the user) is loading (comming) from an excel file in the filesystem. How can I access to the data fields in excel vith VBS for transfere it to the Combobox chooseable elements...

This is my question.

[Brad_Turpin]

Hi Fatih,

Your two main options are to either create an Excel DataPlugin that loads the fields of interest into the Data Portal or to program a VBScript with ActiveX objects that read the Excel field values of interest directly to VBScript variables.  The DataPlugin approach is more robust but always adds Groups and/or Channels to the Data Portal, which may not be ideal (even temporarily).  The ActiveX approach doesn't touch the Data Portal, but it can have trouble with Excel application instancing.  For example, if you happen to have that Excel file open in Excel when you try to load it via ActiveX, the attempt will fail.

I can help you with either approach.  What do you think?

Brad Turpin

DIAdem Product Support Engineer

National Instruments