VBA Example: Targets to Excel

Martin

This macro writes the coordinates for all targets into an Excel sheet. It's easy to modify it for other data.

Open VBA (Alt+F11) and import the form. You also need to put a reference to the  ABB RobotStudio MathUtility and Microsoft Excel

Good luck!

Targets2Xl.zip

Administrator37896,4825347222

Philippe_Vyain

I am very interested by importing targets from robot studio to excel file.

I currently have a station with about 900 targets. ..

I have imported the formes in Robotstudio and Excel but maybe because I am not so familiar with Visual basic I don't understand your sentance "You also need to put a reference to the  ABB RobotStudio MathUtility and Microsoft Excel". I didn't find any "mathutility anywhere" neither in excel nor in robot studio. Would it be possible to get more explaination.

Thanks

Philippe_Vyain

I see there is solution to export the targets from RS to Excel.

Is there any solution for the reverse. ..

Say Load the RS station with target loaded in excel file .

 

Martin

Do like this.

1. From RobotStudio open VBA (Tools/Macro/Visual basic Editor)

2. Import the form (*.frm) in VBA (File/Import File)

3. In VBA, goto Tools/References. In the list that pops up, select "ABB RobotStudio Matyh Utility" and "Microsoft Excel Object Library"

4. In VBA, Double-click on the form in the Project explorer, then select Run/Run UserForm (F5)

It's quite easy to write a macro that imports from Excel to RS, but I don't have time right now. Maybe someone else has?

John Wiberg

Here is another excel example:

Xlmacro.zip

Administrator37896,4827546296

HossamElaarag

Hey Guys, I tried to follow your instrucation but I am a little bit lost. I don't know how I could open VBA in Robotstudio, could someone help me please? 
Thanks