can the excel import wizard pull in data from the excel file name?
I am using the excel import wizard to pull in some excel data and some of the information I need is encoded in the excel file name. Is there any way, using the import wizard, to pull in information from the file name? The wizard by default uses the worksheet name for the JMP table name, but that's not what I am looking for in this case (all my worsheets are 'sheet1'). Ideally I want to 1) name the...