Refresh excel sheet

[Nirubala]

Friends,
How do I refresh an excel sheet based on results from another tab in the same excel file?
Thx

 

[VJR]

Hi Nirubala,

Assuming you are mentioning about the Refresh button on the Data tab.
Either you will have to write a macro and call it from Blue Prism by using the 'Run Macro' action OR write a new Action page for the MS Excel VBO that will refresh a sheet.

 

[Nirubala]

Thanks VJ. Will try it out.

 

[Nirubala]

Hi VJ,

Used VBA and was able to do the refresh.
Now, am stuck with sending an email via Blue Prism using gmail. It gives an error as (Invalid character was found in the mail header "" ).Do you know how to solve this?

thanks for your time.

 

[VJR]

Hi Nirubala,

Haven't come across this error so can't straight away give you a resolution.
I see a lot of web search results for "Invalid character was found in the mail header".
So it looks like an error outside of Blue Prism too.
Could you check those and make changes in your application accordingly and post back your findings.

 

[Nirubala]

I had double quotes around the username when configuring email thinking it is a text and it needs double quotes. After removing that, it started running fine.

Now, am in the phase of posting a file in a folder in a URL. Thanks for your time.

 

[sakshi]

How to Run a Macro in Blue Prism?

 

[Nirubala]

Is it an excel based MACRO?

 

[sakshi]

yes

 

[sakshi]

we have an Action of MS Excel VBO
But when I m entering the Excel name. It throws an error

 

[sakshi]

 

[Nirubala]

To run a macro enabled excel, a file should be saved as .xlsm

To refresh a macro, I did the refresh in the excel itself instead of BluePrism.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Worksheets("Priority").PivotTables("Pivot_Priority").RefreshTable
End Sub

Do check if the file exists in the folder it is trying to search?

 

[sakshi]

The file is there and even it is saved as .xlsm

 

[Nirubala]

Can you pls check why it is showing as .xlsb in the error that you sent?

 

[sakshi]

Its working.
Thanks Nirubala

 

[sumeetsingh56]

I s

Hi Nirubala,

Assuming you are mentioning about the Refresh button on the Data tab.
Either you will have to write a macro and call it from Blue Prism by using the 'Run Macro' action OR write a new Action page for the MS Excel VBO that will refresh a sheet.

Can you Share the code to write in code stage to refresh the Sheet

 

[sumeetsingh56]

Hi VJ,

Used VBA and was able to do the refresh.
Now, am stuck with sending an email via Blue Prism using gmail. It gives an error as (Invalid character was found in the mail header "" ).Do you know how to solve this?

thanks for your time.

Hi Niru Bala ,
Can you share the VBA code of Refresh For pivot Table