problem importing points from Excel

[AkramAero]

Hi everyone
I tried to draw a spline using GSD_PointSplineLoftFromExcel excel file, but when I run the macro, it shows an error message:
"license information for this component. You do not have an appropriate license to use this functionality in the design environment".
Can anyone help?
Thank You

 

[ferdo]

Hi,

Maybe you don't have GSD license?

Regards
Fernando

https://picasaweb.google.com/102257836106335725208

- Romania

https://picasaweb.google.com/103462806772634246699/

- EU

 

[AkramAero]

Hi Fredo,
I have GSD license and it is active

 

[itsmyjob]

I dont know if DS update its code sample from online doc but just for us to better help you.. What is your version of CATIA and version of the catvba file ?

Eric N.
indocti discant et ament meminisse periti ​

 

[ferdo]

Which CATIA release? What OS? 32x or 64x? VBA6 or VBA7? From where did you get the xls file? Maybe is not working in your CATIA release or environment due to VBA version...can you upload here that xls file with some points inside?

Regards
Fernando

https://picasaweb.google.com/102257836106335725208

- Romania

https://picasaweb.google.com/103462806772634246699/

- EU

 

[AkramAero]

Catia P3 V5-6R2014
OS: windows 10 pro 32 bit
Microsoft visual studio 2010
I get the excel file from : Program Files\Dassault Systemes\B24\intel_a\code\command

 

[ferdo]

Well, for me is working, Win10, x64, r25, see here

Regards
Fernando

https://picasaweb.google.com/102257836106335725208

- Romania

https://picasaweb.google.com/103462806772634246699/

- EU

 

[AkramAero]

I know it has to work, but I couldn't find what to fix exactly

 

[ferdo]

Did you had another release installed before? Can you delete first all your CATSettings and try again to run the Excel macro? I didn't do any modification to the excel file...

Regards
Fernando

https://picasaweb.google.com/102257836106335725208

- Romania

https://picasaweb.google.com/103462806772634246699/

- EU

 

[itsmyjob]

do you have catia running before you start the script in excel?

How do you start catia usually ?

Eric N.
indocti discant et ament meminisse periti ​

 

[AkramAero]

I run Catia then I open the excel file

 

[itsmyjob]

ok my feeling is that your excel script is link with a previous catia level, and when the script try to get catia it won't find the open one and will try to start a new one and then you're missing license.

in the script ( go to EXCEL VBA with [kbd]ALT[/kbd] + [kbd]F11[/kbd]) find GetCATIA() the run it one line at a time : bring cursor inside and press [kbd]F8[/kbd]

and check if windows find your running catia or if it's trying to create a new process...

Eric N.
indocti discant et ament meminisse periti ​

 

[AkramAero]

run-time error '429'
ActiveX component can't create object

 

[itsmyjob]

what line?

Eric N.
indocti discant et ament meminisse periti ​

 

[AkramAero]

Problem is in the line 144:
If CATIA Is Nothing Then

 

[JeniaL]

Try to register Catia. This may help. Put On Error Resume Next before If CATIA Is Nothing Then
and see what's going on.