Help
cancel
Turn on suggestions
Showing results for 
Search instead for 
Did you mean: 

How to use RPA to format Excel doc?

Go to answer
ChloeMacIntosh
Level 4

‎16-07-19 08:17 AM

Hello,

I want to use RPA to format an Excel doc - set bottom borders, fill cells with colour, etc.

I cannot use a template for this as different cells will need to have borders set and colours filled each time.

Can anyone advise how to go about this?

Thanks,

------------------------------
Chloe MacIntosh
Automation Developer
Zurich Insurance
Europe/London
------------------------------
0 Likes
1 BEST ANSWER

Helpful Answers

Go to answer
TetsujiJunicho
Level 9
In response to ChloeMacIntosh

‎16-07-19 05:05 PM

Hi,

Here's the Extending the MS Excel VBO: https://portal.blueprism.com/documents/standard?title=extending+the+ms+excel&category=All&lang=1382

Hope this helps.

------------------------------
Tetsuji Junicho
Manager of RPA Practice Grp.
Accenture Japan
Asia/Tokyo
------------------------------

View answer in original post

0 Likes
4 REPLIES 4

Go to answer
GopalBhaire
Level 10

‎16-07-19 11:17 AM

You'll have to edit the Excel VBO to add the mentioned features.

------------------------------
Gopal Bhaire
Analyst
Accenture
------------------------------
0 Likes

Go to answer
ChloeMacIntosh
Level 4
In response to GopalBhaire

‎16-07-19 12:23 PM

Yeah I got that far - I am looking for guidance on building the said features into a code stage.



------------------------------
Chloe MacIntosh
Automation Developer
Zurich Insurance
Europe/London
------------------------------
0 Likes

Go to answer
TetsujiJunicho
Level 9
In response to ChloeMacIntosh

‎16-07-19 05:05 PM

Hi,

Here's the Extending the MS Excel VBO: https://portal.blueprism.com/documents/standard?title=extending+the+ms+excel&category=All&lang=1382

Hope this helps.

------------------------------
Tetsuji Junicho
Manager of RPA Practice Grp.
Accenture Japan
Asia/Tokyo
------------------------------
0 Likes

Go to answer
RoarNilsen
Level 3

‎25-07-19 11:46 AM

Here is an alternative solution if you are able to run Excel macros.
* Run Excel macro from Blue Prism.
* Use VBA in the macro to edit the layout.

Split the VBA code into 2 subs
UpdateExcel        - Macro/sub called from Blue Prism Action with Run Macro from MS Excel VBO
ChangeExcelLayout  - The actual code that changes the layout. Do the layout changes while recording a macro to get some of the VBA code.
Sub UpdateExcel
' Called from Blue Prism Action with Run Macro from MS Excel VBO

   'Turn off error handling to let Blue Prism continue in case of an error
    On Error Resume Next
    
	ThisWorkbook.Worksheets(cMyWorksheet).Activate
    Call ChangeExcelLayout
  	
   'resume Error handling
   On Error GoTo 0
   
End Sub​


------------------------------
Roar Nilsen
Manager
Duit AS
Europe/Oslo
------------------------------
Top