Search results

  1. A

    ActiveWindow option in code stage

    Hi @gil.silva can you help me to create the unfreeze worksheeet action
  2. A

    Recover Stage not working

    HI @Sachin_Kharmale Please help me to solve the above problem
  3. A

    Recover Stage not working

    Thank You So much :):)@Sachin_Kharmale
  4. A

    Recover Stage not working

    Manually How we Unhide the hidden Worksheet .We can Right click on worksheet and click on unhide . and then if hidden worksheet is present it will unhide i want to do code stage for the same
  5. A

    Recover Stage not working

    @VJR @Sachin_Kharmale
  6. A

    Recover Stage not working

    Hi Can Anyone help me create the code stage for: Check that there are no hidden worksheets, if hidden file is there delete it or Unhide Worksheet Thank you
  7. A

    Recover Stage not working

    Hi @VJR @Sachin_Kharmale I am getting an Error. I was created the code stage for unfreeze Worksheet. It Gettiinng an error message please help me. I am attached the picture of code stage
  8. A

    Hi members, Code stage For the Convert data to table format Dim wb, ws As Object Dim excel...

    Hi members, Code stage For the Convert data to table format Dim wb, ws As Object Dim excel, sheet, range As Object Try wb = GetWorkbook(Handle, Workbook) ws = GetWorksheet(Handle, Workbook, Worksheet) wb.Activate() ws.Activate() excel = ws.Application sheet = excel.ActiveSheet range =...
  9. A

    Hi members, Code stage to Colour your table Dim wb, ws As Object Dim excel, sheet, range As...

    Hi members, Code stage to Colour your table Dim wb, ws As Object Dim excel, sheet, range As Object Try wb = GetWorkbook(Handle, Workbook) ws = GetWorksheet(Handle, Workbook, Worksheet) wb.Activate() ws.Activate() excel = ws.Application sheet = excel.ActiveSheet range = sheet.Range(Reference)...
  10. A

    Hi members, code for the Style Your Pivot table code stage Dim wb, ws As Object Dim excel, sheet...

    Hi members, code for the Style Your Pivot table code stage Dim wb, ws As Object Dim excel, sheet As Object Try wb = GetWorkbook(Handle, Workbook) ws = GetWorksheet(Handle, Workbook, Worksheet) wb.Activate() ws.Activate() excel = ws.Application sheet = excel.ActiveSheet...
  11. A

    last two lines sheet.PivotTables(PivotName).SaveData = False...

    last two lines sheet.PivotTables(PivotName).SaveData = False sheet.PivotTables(PivotName).PivotCache.RefreshOnFileOpen = True
  12. A

    Hi members, Any wants to code for the Refresh Data on the file open. or want to reduce the size...

    Hi members, Any wants to code for the Refresh Data on the file open. or want to reduce the size of file you can use the following code stage i am sharing the code Dim wb, ws As Object Dim excel, sheet As Object Try wb = GetWorkbook(Handle, Workbook) ws = GetWorksheet(Handle, Workbook...
  13. A

    Apply filter to pivot table rows

    Hi @Sachin_Kharmale @VJR i am trying to add the date value to the pivot table filter dynamically i created one code stage for that but getting the error So please help me where should i was wrong. I am attached the file of code and i/p o/p
  14. A

    How to apply filter in pivot table with Blue Prism

    i want to Apply filter on pivot pivot table name is PivotTable45 and PivotFields is EOW status change the item to add is PivotItems 28-Dec-2019 should any one help how that will do with dynamicaly using action
  15. A

    How to apply filter in pivot table with Blue Prism

    ActiveSheet.PivotTables("PivotTable45").PivotFields("EOW status change") .PivotItems("28-Dec-2019").Visible = True
  16. A

    Excel Chart Data Update

    getting an error Could not execute code stage: Object reference not set to an instance of an object.
  17. A

    Excel Chart Data Update

    Hi VJR, also need that code please give the run able code with input and output it will help me more thank you in advance
  18. A

    Excel Chart Data Update

    @VJR please give me the picture of input and out to passed in the you code of chart Update. thanks in advance
  19. A

    Pivot table data source

    hi i am also getting same error please any leads help thank you
  20. A

    Excell Pivot Table Coding

    Hi , Anyone help me to How to Change data Source Through Analyze tab of pivot in Blue Prism. Thank You in Advanced
Top