Hi, I'm wondering if it is possible to get the list of sheet names from an excel. It's possible here with valide sheet name : https://communities.sas.com/t5/Base-SAS-Programming/Query-excel-to-find-sheet-name/m-p/45477/highlight/true#M9403 I tested it, it worked. But my sheet names have more than 30 characters. The sheet names will change every week. The excel can contains 20 or 40 sheets per week. Do you know if it's possible to get the list from the excel ? If I import the excel, only valide name or shown. I can read the long name sheet like this : PROC SQL; CONNECT TO EXCEL (PATH='H:\desktop\myexcel.xls'); SELECT * FROM CONNECTION TO EXCEL (SELECT * FROM `loulou.xarpiegewaar@vnpcccparizzz` DISCONNECT FROM EXCEL; QUIT; But I cannot get the entire list of sheets somewhere like in a macro variable or a data set. even from SASHELP.VSTABVW or sashelp.vtable Thanks by advance, Regards Tom
... View more