Hello all,

Can we work on S7ProSim COM object in Excel VBA?
I added the object in refrences and I am able to access the methods and events of the S7PROSimLib but when I run the code it gives "Compiler error :Expected Function or Variable"

It seems that ReadOuputImage is not recognized as valid function/ method.

I was trying following code. It is taken form S7ProSim help manual.


Priovate Sub cmdReadOutputImage_Click()
Dim S7ProSim1 As S7PROSIMLib.S7ProSim
Set S7ProSim1 = New S7PROSIMLib.S7ProSim
Dim errReadOutputImage As Long
Dim lStartIndex As Long
Dim lElementsToRead As Long
Dim DataType As ImageDataTypeConstants
Dim vData As Variant
'***** Read 2 Bytes at the starting address Q 8.0 *****
DataType = S7Byte 'Read type Byte
lStartIndex = 8 'Start at address Q 8.0
lElementsToRead = 2 'Read 2 elements (Bytes)

errReadOutputImage = S7ProSim1.ReadOuputImage(lStartIndex, lElementsToRead, DataType, vData)

End Sub



Regards,
Joey.

Hi Dec,

Appreciate your help. I wonder why it is denying to recognize the method ReadOutputImage at my end.It is still giving the same error. I have attached the Excel Workbook having same code.

Hope you don't mind to have a look at it.

Thanks.