Hello Ahmed,
I confirm your script (the mmult_test() function) works as expected on my side. I tried on two Windows 11 systems. On a corporate PC with strict security rules, the Excel will not let the script to launch the FreeMASTER processes, so I had to run them manually first:
pcmaster /sharex TRQ
pcmaster /sharex SPD
Then the script was able to get access to running instances. Followed by a message:
...which is obvious as I have an empty project in the TRQ instance.
In the 2nd experiment using my home PC, the Excel was able to launch and control the instances. I'm really not sure what can be blocking the access on your side. Can you try the same on a different PC?
Regards,
Michal
Hello Ahmed,
the script below works in my test Excel file. Make sure you have the objects referenced in VBA. Go to Tools/References menu and check both FreeMASTER and also mmaster object (you may need to browse for mmaster.dll in the FreeMASTER installation).
Dim mult As McbMult
Sub start_A()
If mult Is Nothing Then
Set mult = New McbMult
End If
Set a = mult.GetAppObject("A", 1)
End Sub
Sub start_B()
If mult Is Nothing Then
Set mult = New McbMult
End If
Set b = mult.GetAppObject("B", 1)
End Sub
Sub mmult_test()
If mult Is Nothing Then
Set mult = New McbMult
End If
Dim a As McbPcm
Dim b As McbPcm
Set a = mult.GetAppObject("A", 1)
Set b = mult.GetAppObject("B", 1)
If a.ReadVariable("var16", v1, t1, m1) Then
MsgBox ("Variable from instance A " + t1)
Else
MsgBox ("Error reading from instance A: " + m1)
End If
If b.ReadVariable("var16", v2, t2, m2) Then
MsgBox ("Variable from instance B " + t2)
Else
MsgBox ("Error reading from instance B: " + m2)
End If
End Sub
Hello Michal,
Thank you for your help. It opens two new FreeMaster files momentarily and then gives this error.
on this line:
I replaced "A" & "B" by the names of my files written like "SpdControl.pmp" and tried also to write the total pathes of files since I want to open these two files not to open two new instances. I had the objects referenced in VBA.
Hello,
I have tested the Excel script on a PC with fresh Windows 11 and the latest Excel 32bit. All seem to work properly. Is it possible for you to test on another PC?
In the meanwhile, I have noticed that on some of our corporate PCs, the GetAppObject fails to start the FreeMASTER process due to a security policy. The failed start can be seen in the "Protection History" log in Windows Security panel (picture attached).
Anyway, if FreeMASTER is started manually with the proper "/sharex" option, then the VBA scripts runs normally - so this is must be a different issue from yours.
So far, no answer to your issue. Let's continue investigating. Please finish your experiment with manual start of the shared instances and also please try on a different PC.
Thank you,
Michal
The /sharex is a command-line option which you can use as a parameter when running the FreeMASTER process (pcmaster.exe). You need to run it manually from command line prompt, or you can create a launcher icon with the parameter.
Steps to run it manually.
- Open Windows Explorer and browse to "c:\NXP\FreeMASTER 3.2"
- Right click the FreeMASTER folder and select "Open in Terminal"
- Type .\pcmaster.exe /sharex NAME
- The NAME is your name which later use in the GetAppObject() call
Regards,
Michal
When I write this command as shown, it opens a new FreeMaster project for moments and close it away. It doesn't open the already created project "SpdControl.pmp" why?
It just runs the two instances and cannot access them and gives the error in the figure below.
The examples you mentioned tries to access one FreeMaster only not two. Accessing one FreeMaster had worked with me before.
