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.
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...
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...
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...
I need to get files that were created today and move these files to another folder. Can I use the File Management Utility to get the files and put a filter to only copy those files with a 'Created' date of today? How will I do this?
Hi
I am quite new to this so please bear with.
I am bringing in a .csv file into a Collection for input into an application.
One of the columns (Unit Price) is in a format using a dot seperator eg. 2.16. The application requires this data to use a comma seperator i.e. 2,16.
How do I convert the...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.