cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - Want the oppurtunity to discuss enhancements to PTC products? Join a working group! X

MS Excel 2016 connect to Creo 3.0 fail?

kai-2
7-Bedrock

MS Excel 2016 connect to Creo 3.0 fail?

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

2016-06-21_233416.jpg

  1-2)   vb_api_register.bat  =>Done

  1-3)   Creo Parametric VB API Type Library for Creo Parametric  =>Done

2016-06-21_234724.jpg



2) Here is the error message (code).

It shows cAC = Nothing .Why?

2016-06-21_232956.jpg

2016-06-21_233040.jpg


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

===========================================



This thread is inactive and closed by the PTC Community Management Team. If you would like to provide a reply and re-open this thread, please notify the moderator and reference the thread. You may also use "Start a topic" button to ask a new question. Please be sure to include what version of the PTC product you are using so another community member knowledgeable about your version may be able to assist.
ACCEPTED SOLUTION

Accepted Solutions
MartinHanak
24-Ruby III
(To:kai-2)

Hi,

I am almost sure that Excel 2016 is not supported. Please ask PTC Support to be sure.

MH


Martin Hanák

View solution in original post

3 REPLIES 3
MartinHanak
24-Ruby III
(To:kai-2)

Hi,

I am almost sure that Excel 2016 is not supported. Please ask PTC Support to be sure.

MH


Martin Hanák

Hi Martin,

Thank you for your reply, I will try to contact the PTC support, to see how to resolve this problem.

KC

kai-2
7-Bedrock
(To:kai-2)

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)

Announcements


Top Tags