DIAdem

cancel
Showing results for 
Search instead for 
Did you mean: 

Userform in Excel

Hello everyone
I have created a userform in excel with VBS in Diadem and want to call Userform in Diadem, but my program does not work. Can someone tell me where is the mistake? my Code is :

 

Set oExcel = CreateObject("Excel.Application")         ' Excel öffnen
oExcel.Visible = True
oExcel.Workbooks.Add()
Set oWBook = oExcel.Activeworkbook
Dim mynewform 
Set mynewform = oExcel.Application.VBE.ActiveVBProject.VBComponents.Add(3) 
With mynewform
.Properties("Height") = 200
.Properties("Width") = 300
.Properties("Caption") = "hoo"
End With

mynewform.Visible= True            'hier is problem

0 Kudos
Message 1 of 2
(2,021 Views)

Hello Fazel,

 

I tried to reproduce your issue, however got stuck at some point. Therefore I wonder which versions you are using. I tried to reproduce with DIAdem 2017 SP1 by creating a script, and have Office 365 1905.

I am stuck already a few lines earlier, the property Properties seems to not exist:

2019-07-09_17-45-21.png

 

Please let me know which versions of the softwares you are using. If possible, provide files with your code as well, please.


Ingo – LabVIEW 2013, 2014, 2015, 2016, 2017, 2018, NXG 2.0, 2.1, 3.0
CLADMSD
0 Kudos
Message 2 of 2
(1,918 Views)