Robot OS with excel vba

[Anonymous]

Hi.

I need your help.

I need create my makro with excel vba to do a model to bridge deck. I want learnt about de Robot OS and before start my model, I am testing some simples makros but I can not understand why "error 13: type mistache" appear when I run simple makro like I show in printscrin.

Sorry my english.

Thanks a lot.

Márcio Teixeira

[Rafal.Gaweda]

Have you added reference to Robot Object Modeler ..?
In which line do you see error ?

[Anonymous]

yes I added.

The error appears in line: "Set s = robapp.Project.Structure"

[Rafal.Gaweda]

See this thread:
http://forums.autodesk.com/t5/robot-structural-analysis/vba-excel-macro-for-any-object-geometry-modi...

[Anonymous]

I can't find what is wrong.

I show printscrin with references.

What else references is necessary?

[Rafal.Gaweda · Accepted solution]

Turn off .. Kernel... in References.

[Anonymous]

Nice, worked.

Thanks a lot.

Márcio Teixeira

[Anonymous]

Hi again.

Before close that topic I have one more error (I'm to learnt yet) in my macro when I was create a new support. The error said "object required".

Please watch my printscrin.

Thanks

Márcio Teixera

[Rafal.Gaweda · Accepted solution]

Do you have this :?

[Anonymous]

yes, I have in top (declarations). 

But inside all subs () is necessary start by:

"Dim Robapp As RobotApplication
Set Robapp = New RobotApplication" ? 

[Anonymous]

I do something with you said, Public, dim and set and is running now.

Thanks

Márcio Teixeira

[Rafal.Gaweda]

Take any of them and check:
http://forums.autodesk.com/t5/robot-structural-analysis/useful-addins-for-robot-api/td-p/3899448