SS&C Blue Prism Community

FrankieTEWV

Hello,I am automating a task that a team does which is downloading an excel report and uploading it into a system. That part I have built and works, however before it uploads the excel report into the system it needs to do some actions within excel a...

FrankieTEWV · 23-10-24

Hello,I have an excel file in the xlsx format. I need to do a find and replace function so it finds all the comma's and replace it with a blank space.I am using the OLEDB actions - the OLEDB 'Set Connection' and 'Open' action work - however i am gett...

FrankieTEWV · 29-02-24

Hello, Im struggling to attach to a browser that is already running. We have other automations which we have set up to do this and have no issues so not sure whats causing this issue however please see details below ... My automation is logging in...

FrankieTEWV · 15-01-24

Hello, The automation I'm currently building involves downloading a leavers report and from that report the deactivation date is read (dd/mm/yyyy) and then using a write stage the deactivation date is inputted into a date box on a system to deactiva...

FrankieTEWV · 18-10-23

Hello All, Anyone using ESR / Oracle in their automations - have you come across an issue where the automation will be working in Oracle updating a staff record with no issues and then all of a sudden it will close oracle, causing the automation to f...

FrankieTEWV

Thanks so much - i will give this a go

FrankieTEWV · 30-10-24

You have been more than helpful so thank you. Ive currently downloaded the excel as a csv > got csv as collection then created new excel workbook and wrote the collection data into new excel and saved as xlsx then ran the oled b actions and it did wo...

FrankieTEWV · 29-10-24

Thank you i understand what you mean now.Ive checked the format on the cell looks like its set to 'General'I tried to follow the SQL you gave me in the execute oledb action but got this error - should that SQL not be done in the oledb execute action?...

FrankieTEWV · 28-10-24

also see below which shows no rules

FrankieTEWV · 28-10-24

Hi Michael, ive gone on the excel report clicked in any cell > gone to find & select > go to special > conditional formats > OK > and it returned "no cells were found" which suggests no formatting on any cell in the excel. But there must be as the ex...

SS&C Blue Prism Community

User Statistics

User Activity

Excel Actions

Error on OLEDB Execute stage

Unable to attach to browser which is already running

Calendar Date Selection

ESR / Orcale closing

Re: Excel Actions

Re: Error on OLEDB Execute stage

Re: Error on OLEDB Execute stage

Re: Error on OLEDB Execute stage

Re: Error on OLEDB Execute stage