Community Tip - You can subscribe to a forum, label or individual post and receive email notifications when someone posts a new topic or reply. Learn more! X
Hi All,
First here and I have a question about MS Excel 2016 connect to Creo 3.0 fail.
I use the same VBA Code,it can work in office PC(Excel 2007 =>Creo 3.0) but It can't work in my laptop (Excel 2016=>Creo 3.0)
Only a little different is MS Excel Version (2007<=>2016),I don't know what the problem is .
Can anyone give me some help?
------------------------------------
1) Setting .
1-1) PRO_COMM_MSG_EXE =>Done
1-2) vb_api_register.bat =>Done
1-3) Creo Parametric VB API Type Library for Creo Parametric =>Done
2) Here is the error message (code).
It shows cAC = Nothing .Why?
3) Here is my VBA Code.
===========================================
Private Sub Start_Creo_Click()
Dim asyncConnection As IpfcAsyncConnection
Dim cAC As CCpfcAsyncConnection
Dim session As IpfcBaseSession
Dim descModel As IpfcModelDescriptor
Dim descModelCreate As CCpfcModelDescriptor
Dim options As IpfcRetrieveModelOptions
Dim model As IpfcModel
Dim workDir As String
Dim position As Integer
On Error GoTo RunError
'======================================================================
Set cAC = New CCpfcAsyncConnection
Set asyncConnection = cAC.Connect(DBNull, DBNull, ".", 5)
RunError:
If Err.Number <> 0 Then
If Not asyncConnection Is Nothing Then
MsgBox "Creo is running"
Else:
Set asyncConnection = cAC.Start("D:\PTC\Creo 3.0\M070\Parametric\bin\parametric.exe" + " -g:no_graphics -i:rpc_input", ".")
Set session = asyncConnection.session
End If
End If
End Sub
===========================================
Solved! Go to Solution.
Hi,
I am almost sure that Excel 2016 is not supported. Please ask PTC Support to be sure.
MH
Hi,
I am almost sure that Excel 2016 is not supported. Please ask PTC Support to be sure.
MH
Hi Martin,
Thank you for your reply, I will try to contact the PTC support, to see how to resolve this problem.
KC
Hi All,
PTC's message as below.The platform support for Creo 3.0.
Microsoft Office 2010 (base version and service packs) =>YES
Microsoft Office 2013 (base version and service packs) => YES (from M050)