SS&C Blue Prism Community

MarkWhitford · 24-06-21

I'm familiar with the "Get Worksheet Names" action of the MS Excel VBO in BP 6.5.1.However this returns ALL Worksheet Names including Hidden.I need a solution that returns ONLY Visible Worksheet Names in Excel Workbooks that have a number of hiddenWo...

MarkWhitford · 29-06-21

Hi Manish,You were 100% correct, I must have missed something when I first tested the solution.I tested it again from the process and it worked perfectly !Thanks for your help.Best RegardsMark Whitford

MarkWhitford · 28-06-21

Hi Manish,I tried the suggested code in a copy of the "Get Worksheet Names" action to get only visible worksheets, as follows.Dim wb As Object = GetWorkbook(Handle, WorkbookName)Dim sheets as Object = wb.SheetsWorksheet_Names = New DataTable()Workshe...

MarkWhitford · 24-06-21

Thank you Manish, I will try this and post the result.ThanksMark

SS&C Blue Prism Community

User Statistics

User Activity

Get only Visible Excel Worksheet Names

Re: Get only Visible Excel Worksheet Names

Re: Get only Visible Excel Worksheet Names

Re: Get only Visible Excel Worksheet Names