Hi there,
I am creating several Smart View template retrieves in Excel, using some mild VBA to retrieve data and metadata, and to spit out copies of certain tabs to new worksheets in the same workbook. The VBA includes a loop to go through each spreadsheet to retrieve the data.
Over time, the workbook accumulates some random worksheets sheets that are hidden. I was right-clicking to perform another action, and happened to notice the 'unhide' menu option was activated. I knew that I didn't create/store any hidden worksheets, so I selected unhide and found these random, junk sheets in my file. These sheets have really long, 31-character names (yup 31, not 32) that look like random alphanumeric characters. The spreadsheets are completely empty.
Has anyone else seen this? If so, does anyone have any ideas on how to keep this from happening? These hidden worksheets screw up the loop in my Smart View retrieve macro.
Thank you!!
I am creating several Smart View template retrieves in Excel, using some mild VBA to retrieve data and metadata, and to spit out copies of certain tabs to new worksheets in the same workbook. The VBA includes a loop to go through each spreadsheet to retrieve the data.
Over time, the workbook accumulates some random worksheets sheets that are hidden. I was right-clicking to perform another action, and happened to notice the 'unhide' menu option was activated. I knew that I didn't create/store any hidden worksheets, so I selected unhide and found these random, junk sheets in my file. These sheets have really long, 31-character names (yup 31, not 32) that look like random alphanumeric characters. The spreadsheets are completely empty.
Has anyone else seen this? If so, does anyone have any ideas on how to keep this from happening? These hidden worksheets screw up the loop in my Smart View retrieve macro.
Thank you!!