Hi All
I need to test the name of a worksheet tab in an Excel file. I use XLSOpen() to open the file and the help says I can use "LeafName" on an xlsDocument variable but I cant make it work.
If I use myXlsDocumentVariable..LeafName the syntax checker says the double dot is not recognized.
If I use myXlsDocumentVariable.LeafName the syntax checker is OK but it fails during runtime with "LeafName is not a valid column" error message.
How can I get the worksheet (leaf) name ?
Thanks
[UPDATE] - I found it - I need to use the property "WorksheetName" as per the Intellisense suggestion. The WD help file says "LeafName" but Intellisense says "WorksheetName". All good now. Thanks for reading
Edited 1 time(s). Last edit at 04/28/2020 10:48AM by JP.