Excel VBA Utility

[richarddenton]

Hi guys,

Something we discussed the other day was better interaction with VBA - e.g. you can write a snippet of VBA code and “send” it to Excel rather than embedding it into the worksheet. Therefore you would utilise the capabilities of VBA but control it from UiPath. Obviously you would have to have to maintain control over this as we know people love to go nuts with VBA

Could this be included within the new “WriteCode” activity? What do others think?

Richard

[andrzej.kniola (Andrzej Knioła)]

That would be really useful and enable a lot more people to contribute.

How I’d see it though, is not part of WriteCode activity, but something more like InjectJsScript. Some parts could be common (editor maybe?), but since the purpose is different (run code externally vs internally) I’d keep it separate.

One thing to overcome is the usual default limitations for running code in Excel, but that shouldn’t be too hard.

Regards,
Andrzej

[adrian (Petre Dorache)]

We already implemented “Invoke Code” activity which will allow to insert snippets of VB.Net
Now it is in pull request phase and hopefully we’ll have it soon for you guys to experiment with it.

Adrian.

[badita (Mihai Badita)]

Code activity should go with code activity:

Code Activity - Creating my own algorithms

I wanna use code to be more fast my development, instead of create all the things in flow mode. Using code to manipulate data and flow to organize, but I think that code some parts will be improve my development. So, my question is, has some possibility to create code parts to make data manipulation?

This is Excel VBA Activity - ability to write Macros in UiPath and execute them against an Excel file. This one is more complicated to achieve. At least I don’t see a way for enabling autocomplete and security issues may appear; so more difficult to implement.

[adrian (Petre Dorache)]

I think that with invoke code it will be possible to write VB.Net code that automates Excel

Adrian.

[badita (Mihai Badita)]

@adrian

I think that with invoke code it will be possible to write VB.Net code that automates Excel

Is it? Even if it is I think this should go as a separate VBA activity.

[adrian (Petre Dorache)]

I never actually tried it but i’m quite confident that it should work. It might get quite complex though

Adrian.

[richarddenton]

I don’t like complex. I’m not clever enough

[adrian (Petre Dorache)]

neither do I

[richarddenton]

So now we have Invoke VBA (apparently since Decembe!! - it’s amazing! )

Thanks @Enterprise