import excel files with wildcard in names
Posted: Wed Nov 28, 2018 10:37 am
Hi EVIEWS GURUS,
I have many excel file in a folder that I want to import all of them to EVIEWS. The name of the excel files vary, but all end with "reviewed". Is that possible to write a program:
1. pick out all the excel files in a certain folder and import them(then I will remove those excel I don't want);
2. or even better: pick out all the excel files in certain path with a wildcard in names, like *reviewed.xls?
Thanks!
BC
I have many excel file in a folder that I want to import all of them to EVIEWS. The name of the excel files vary, but all end with "reviewed". Is that possible to write a program:
1. pick out all the excel files in a certain folder and import them(then I will remove those excel I don't want);
2. or even better: pick out all the excel files in certain path with a wildcard in names, like *reviewed.xls?
Thanks!
BC