Recent content by Ray52

I'm getting this error using Open Workbook action. Does anyone know what is causing this error.

I have to delete/clear the data in a certain worksheet range and paste new data in the same range. I'm using the Delete action then Copy and Paste Worksheet Range action in the MS Excel Extended VBO. In the same worksheet, there is a column with the vlookup formula referencing a cell which forms...

I need to copy a worksheet range from one workbook to another and paste special this as an image/picture in another workbook. I also need to paste the worksheet range into an email body. Could you please tell me how to go about this in blueprism.

I get the same error message and its not an access issue.

The Excel file is opened by an application and not by blueprism. When I attach and then try to save the file to another location using the Excel VBO, it is saved in a new instance resulting in the new blank workbook being saved instead of the already opened workbook. Can anyone please tell me...

Hi I have to run a batch file. I'm using the Start Process in the Utility - Environment vbo. I then get this security warning message. Do I have to spy the Run button to execute the batch file. If so, how do I spy without having an application or what application do I have to create in the...

I used Run Macro on the Excel VBO instead. Thank you.

A button on an excel worksheet saves the worksheet into a text file. I created an excel object and tried to spy the button in Region mode. It finds the button but not clicking on it. Please help me find the right solution to click the button. PS. I also considered creating the text file in...

I have been using most the Region mode of spying the elements on this application. When writing data into a field using global send keys, blue prism writes incorrect data at times. I then followed it with a Read stage to check if the correct value was inserted, the incorrect value is also read...

It works perfectly. No I changed the account number.

I managed to copy the text using a utility with the action "Read Delimited Text File" which output a collection. Then write the collection using the Excel VBO.

Thanks Pete. I tried to follow your suggestion but it is not clear to me what the expectation is in the output data collection on Get Worksheet As Collection. The files I am copying from is in Notepad (.txt) i.e. not in excel. I am trying to write the text from Notepad files into excel worksheets.

I need to copy the contents of several text files into an excel workbook but on different worksheets. After I copied the contents from Notepad, I want to paste this into the excel worksheet. I could either keep the worksheet open in the previous step or have closed the workbook and re-open it in...

Pete, Thank you for your patience. I was following a solution found in another forum where the Collection fields had to be read. Not sure why the dot notation was not used there. I managed to get it right with your guidance. Thank you very much for your help.

So are you saying that I will be able to get only the files using Get Files with a string pattern in the filename(can use wildcard). Will string pattern only look at filename? Can it not look at "Created" date in the string pattern? If I bring in all the files in the folder using Get Files...