Search results

Do your macros take parameters etc? We have no idea what the macros look like.

1. Write out the code in VBA. THEN: 2. Remove all uses all the Set keyword. 3. Replace all Excel enumeration terms with the Int32 value (so e.g xlValues might be -4192). You can do this by running to breakpoint in Excel and then hover over all such enum values. 4. Always use parentheses for...

What have you done in BP? And what is the error that you get?

This is unclear. Can you give your scenario clearly. Profiles? Accounts? Screenshot of the Outlook??

Hi sumit. SQL Management Studio may automatically COMMIT transactions. So look at Begin and Commit transactions in your code. Either as actions in the VBO, or else in your SQL

If that Excel file is growing, you're going to hit a sheet limit soon! Perhaps look into an OLEDB connection to the closed Excel file, and read into a collection that way.

This all depend on whether you are awaiting a return value from the macro to your Blue Prism code, or not. If not, then perhaps you can spy the InputBox, and write inputs etc. However it might be best to rewrite the macro code in VB/Blue Prism or re-write the macro(depending on ownership) to...

You can add an action to the File management VBO: If Directory.Exists(folderPath) Then Dim dInfo As DirectoryInfo = New DirectoryInfo(folderPath) dInfo.Attributes = dInfo.Attributes Or FileAttributes.Hidden End If where folderPath is an input parameter

Code stages are usually written in Visual Basic or C#. Visual Basic usually easier to use if you wrote VBA macros. Your best bet is to look at MSDN, or some such docs. The Blue Prism Collection is a .NET DataTable object, so look for that in the docs...

The key part of all this is that it has to be enabled from the server-side as well as on the client, so you may need to discuss with SAP administrators if it is not already enabled.

Great stuff to get it going! So now it works, but very slow? Show the work as screenshots, and we can have a look at it

I meant I have actually used this syntax before, so it works, but not the exact line I gave you (with startup parameters). The way I use it, my process doesn't have statup parameters, but you desire a ticket number, so i thought maybe you have a start parameter with ticket id. That's why I got...

This is because you don't have en Excel instance with that handle you are passing. Nothing to do with my code. Look into how the Excel VBO works. Sorry

I haven't tested that syntax, and I added the input XML - so please check the syntax and fix any typos. Can you check the Blue Prism help document from the application, and look for automatec command? Also BPUserName, and BPPassword - nothing to do with Windows login. They will have to have the...

Looks like you have key columns of 'Ar', 'Allegato' and 'Soc' which define an asset. Then you want any unique (by AR )from this month to be moved, and placed in a 'ToBeProcessed' Collection? Many ways to do it. You can do some loops etc, nested loop outer loop = thisMonthsColl, and then inner...

Do you have the 'Utility - Environment' VBO? It should be in there

Ahhh yes! Different VDIs (runtime resources). Use the Start Process Action as above. Create the argument string and feed it as a parameter to the 'Start Process' Action.

Have a look at your images please? The files do NOT look very different to me... Can you edit the OP to make a clear & simple example of what the requirements are? Generally you can filter a collection with a 'filter collection' Action from the Collection manipulation VBO which takes a...

Can we all clarify the jargon? I am unsure of what is referred to by 'bot'. If you want another machine to run a process, then you could create calculated parameters to the automatec executable command: 'Start Process' Action of Environment VBO: Application: "automatec" Arguments: "/run...

Almost everything that you can do on Excel can be done through code actions. Excel exposes its functionality through COM. You can loop through pivot tables and/or refresh individually. Look at the VBA docs(better for reference/explanation) and such code can usually be translated into VB.Net...