Hello, I'm new to Blue Prism, and looking for a way to copy Excel range as image and paste it to Outlook item.
I know "CopyPicture" method in VBA but I have no idea what I can do in Blue Prism.
Maybe I will have to use Code Stage?
I appreciate if any one of you give me an advise. Thank you.
Hello,
i'm currently encountering an issue with my project.
I have to download multiple excel files from an Intranet. Then, open them one by one and call a specific macro (The same macro exists in all the files).
While running the macro, i noticed that there's a runtime error with the macro...
I automated another program that outputs reports in Excel format - however, the Excel format it saves the files as is older. I have Blue Prism interact with the program and save it to an Azure share - the Excel files are then imported by another system process. The other system process is...
Hi,
I have a process that will execute many SAP transactions, some returning large amounts of data, and create an Excel workbook (Output.xlsx) with separate worksheets containing the data from each SAP transaction.
As each SAP transaction is run, we have SAP export the data to Excel. For...
I am opening a new Excel workbook through one excel workbook(AFO) which is already open. Now after opening the new workbook I am getting issues with attaching. But if I manually close the previous workbook(the not required one), then everything seems to work perfectly.
Is there a way to close...
I have an link enabled excel workbook, which opened manually gives a pop up to enter credentials to connect to the data source. If the same excel is opened from Blue Prism, it throws a pop up of : Excel has links, if you trust: update or not update pop up. I added an action via code stage to...
Has anyone here tried to Automate an Excel with Analysis for BI Office Launcher? I tried to use the Open Workbook Action under MS Excel VBO but the Analysis Tab is missing. Please let us know if there is any other way to open the file. Thank you!
I have a scenario where I have three complex excel files. Each file has thirty to forty worksheets. Each worksheet in excel has to be saved with it's business center number as file name, in a created folder after some data manipulation. For example. file A has 1,2,3,4,centers, and hence 4files...
Hello,
I am getting an error message when using the state in Blue Prism where the data is being read from excel into a collection. There are 30 columns in my spreadsheet and this process works with the first 14 and stops at Column 15. This is the error message I get:
2/18/2020 12:24:59 PM...
Hello everyone,
is there a way how to attach the excel which gets automatically opened by SAP when robot is saving report as spreadsheet? But the Excel isn't opened within the RPA Excel instance...
So far I kill the excel process and open the excel again but it doesn't feel right, especially...
The Utility Environment - Kill Process action unpredictably ends up in a 'warning' state. The process that is to be killed is Excel.
Since this Kill isn't working the only way to exit the warning state is by manually killing the process in the task manager, that apparently gets stuck running in...
Hi all,
I am currently encountering a problem with the MS Excel VBO - SaveWorkbookAs action. At my client we are in a transition from Win7 to Win10 and I am testing all existing processes and objects. The SaveWorkbookAs action doens't work like it used to on our Win7 resource machine. Nothing...
Hi team,
Am using OLEDB with Excel (Office 365). When am giving the connection string, its working fine. But when executing the connection, it shows "
Error: db_sec_e_auth_failed(0x80040E4D)" error,
Can someone help me on this.
I have a pretty simple process. I want to open an Excel workbook with macros and run a macro.
My process looks like this:
Start
Create Excel Instance
Open Workbook
Run Macro
End
I'm getting an error "Could not execute code stage because exception thrown by code stage: The message filter...
Hi,
I'm currently converting an Excel file to CSV.
Step 1: Get data into collection
Step 2: Convert collection to CSV
Step 3: write it into a file.
It works, but there is a problem with Data format error.
For example:
Excel value - 9781621577720
CSV value - 9.78162E+12
I'd like to know if...
Dear Members,
I am new to blue prism and i would like to create a process which involves running a single Macro in different workbooks and different worksheets of excel so can you please help make dynamic values of macros for Blue Prism so whenever macro is running it is picking itself...
I have 4 columns in a spreadsheet that I need to paste on another workbook. The size and order of these 4 columns on the source sheet vary. The Column names are consistent. I need to paste the columns on the destination workbook in a certain order going by their column name. The solution that I...
Hi,
We are developing a robot to automate some reporting analysis and submission to different process owner.
Basically we extract data from SAP, make some mapping query in access and then extract data into excel in different report to different user.
To write in excel we are using connection...
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.