SS&C Blue Prism Community

AtliHarðarson · 07-04-22

How can I change this codestage for GetWorksheet to only get visibly values? To read only visible data how would this codestage look like? Dim ws as Object = _ GetWorksheet(handle, workbookname, worksheetname, False) ' Do we have a sheet? she...

AtliHarðarson · 07-04-22

Hi, Can the template Get Worksheet As Collection be altered so it only gets visible data? Dim ws as Object = _ GetWorksheet(handle, workbookname, worksheetname, False) ' Do we have a sheet? sheetexists = ws IsNot Nothing ' No sheet? No entry....

AtliHarðarson · 06-12-21

Seasons greetings! :) Best Regards Atli------------------------------Atli Harðarson------------------------------

AtliHarðarson · 29-08-21

Hello!I've succesfullt been able to retrieve emails from folders&subfolders and also shared mailboxes but I'm having issues reading from a Public Folder Does anyone have any examples of succesfully reading from one?------------------------------Atli...

AtliHarðarson · 17-05-20

Hey, I'm using write binary to get file into blue prism, how can I write out the binary data to text data item?I'm shooting a http message and I need to have the binary file as my body so it's[{File Contents "[BinaryData here]"}]I need it as text, an...

AtliHarðarson · 22-11-22

I would say this is a very important process to implement. My team had dozens of Pending restart sessions troubling our nightruns. But this has solved it. Is there any way this could pickup on "Warning" like it finds Pending? Dim sortInfo As New Se...

AtliHarðarson · 03-05-22

Thanks Eric, solved the UTF-8 Had to change UTF-8 to 65001, now also trying to solve the ";" delimiter :) Using cn As New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & Folder & ";Extended Properties=""Text;HDR=" & HDRString & ";...

AtliHarðarson · 02-05-22

Hi Eric, this is really promising! Is there any way for me to change the encoding options? It doesn't really like my CSV files because of special characters. Hálsaþing 4;203;1116498;1000;Kópavogsbær;18.04.2011 00:00;02.05.2011 09:18;48000;44450;20...

AtliHarðarson · 31-03-22

Hi Eric, just wanted to thank you for this. Got me out of a troubleshooting loop I've been in the last week.------------------------------Atli Harðarson------------------------------

AtliHarðarson · 21-01-22

Hi Eric, I've had this hanging popup interrupting my process for over a year now, what you mention is changing it to look for dialogs that have "Microsoft VIsual Basic" in title bar is just what I need. But how can I edit the code to also wait for t...

SS&C Blue Prism Community

User Statistics

User Activity

Blue Prism Excel VBO Get Worksheet Only Visible?

Blue Prism Excel VBO Get Worksheet Only Visible?

#12DaysofRPA Season greetings!

MS Outlook VBO

How to get binary data to text?

RE: Scheduler Pending Session Starter VBO

RE: Working with large CSV files? Just chunk it! :-)

RE: Working with large CSV files? Just chunk it! :-)

RE: Move Email to Inbox Sub Folder action - Failed to locate folder 'xxxxx'

RE: Hi Ian, The attached VBO has…