VBA and Robot

[Anonymous]

Hi all,

I recently finished my formation in Civil Engineering on the structural area.  I started working on the steel structures field as a designer and have been using Robot and Excel as my main tools.

I found out in this forums that we can merge the two via VBA and would like to ask if someone could clarified me what exactly can we do with  VBA on Robot. How far do you guys use to go? Do the structural designers here on the forums use this technics a lot? I saw here on the forum a lot of examples of APIs but would like to know if it is possible to go beyond that.

Currently I have zero knowledge in VBA and was thinking in taking a course in VBA applied to Excel. Would that be a good start? Or maybe a course orientated only to VBA programing is

better?

Thanks a lot for the help.

[rsousa_ · Accepted solution]

You can do a lot with vba and Robot. Please see the robot api user guide to see all the things you can do with robot api.
Everytime I have to do some tasks over and over again, I solve that with VB.
I know You can go much further than you see in this fórum, it is and equation with your dreams, your skills (regarding programming) and available functions of Robot Object Model.

Basically you need to learn one language (visual basic ou C). Then you can do some code in VBA (office applications, other applications with VBA implemented) , in visual studio (comunity edition is now free!) or anywhere else... You will benefit a lot, trust me!
Regards

[Anonymous]

Hi thanks for the reply.

So by learning the VBA language will i be able to take advantage of the full robot´s API potential? Will the use of VBA on Excel be enought? Or are their otehr alternatives? 

[Rafal.Gaweda]

Examples :

http://www.4shared.com/file/lhZsHsAIce/AU2013.html

http://au.autodesk.com/au-online/classes-on-demand/class-catalog/2014/robot-structural-analysis-prof...

[rsousa_]

mgt89,

You will not learn VBA, you will learn VB. You can use VB in all applications that have vb implemented. Excel is just a piece of this world, it is not the world....
"Will the use of VBA on Excel be enought?" - it depends on what you want to do.
"Or are their otehr alternatives?" - of course there are... but first you have to learn the programming language. The fundamentals are application independent. Then you could learn each api for each application... Robot, excel. etc....

[Anonymous]

Ok I think my head is a little confused 😛

So first I will start by learning a programming language like Visual Basic. After that I can apply that knowledge to different programs (that you call api right?) like excel, robot etc. Am I understanding this correctly?

I´m thinking on taking a course on VBA in excel. Do you think that will be a good start?

Thanks 🙂

[Rafal.Gaweda]

VB \ VBA is pretty simple.
Open my examples you will see the code (ALT+F11 to go to VBA editor) you will understand

[Anonymous]

can you upload the files again,please? Because These files are death