Recent content by Anton Hosang

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...