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
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
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
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 =...
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)...
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...
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...
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
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
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.