SS&C Blue Prism Community

MatteoPavone · 30-06-20

Hello, Everyone.I recently had a problem with copy and paste values. I try to explain in detail:I'm automating some processes that are done through excel. Mainly, the sheets are populated through VLOOKUP:1. Insert a formula in the right cell (ex. A1)...

MatteoPavone · 14-05-20

Hello everyone!I'm experiencing the following error while using the action on MS Excel VBO - Copy and paste worksheet range: failed to copy worksheet:error message: 'PasteSpecial method of Range class failed. I'm actually using the action MS Excel V...

MatteoPavone · 07-05-20

Hi! I'm trying to launch a process from cmd, I use the action "Start Process" in the vbo utility. I insert the path where I find the cmd.exe and write an argument but the process doesn't recognize it, i.e. it opens a cmd window without argument. Can ...

MatteoPavone · 15-07-20

Hi Nicholas,Thanks for the answer.The workflow is:1. SET CELL VALUE in "C2" -> "=IF(ISNA(VLOOKUP(A4,'["&[Macro Pivot.Nome workbook]&"]"&[Macro Pivot.Nome worksheet]&"'!G:J,4,0)),"&0&",VLOOKUP(A4,'["&[Macro Pivot.Nome workbook]&"]"&[Macro Pivot.Nome w...

MatteoPavone · 08-05-20

Essentially I need to run cmd and relative arguments to run a query because when I use the object "get collection" I had a memory problem (System. OutOfMemoryException)------------------------------Matteo Pavone------------------------------

MatteoPavone · 08-05-20

Hi Raul!Thanks for your answer!So I write the .bat file and then I use "Start Process" with "cmd.exe" and argument the path of the .bat file right?Thanks againMatteo------------------------------Matteo Pavone------------------------------

SS&C Blue Prism Community

User Statistics

User Activity

Error Pastespecial in range Values

Copy and paste worksheet range issues

Object

RE: Error Pastespecial in range Values

RE: Object

RE: Object