Nelson78
Well-known Member
- Joined
- Sep 11, 2017
- Messages
- 526
- Office Version
- 2007
Hello everybody.
I have a folder that contains many workbooks.
I need, for any workbook:
1) check if is a .xlsm workbook;
2) if yes, check if a sheet named "Record" exists;
3) if exists, import stuff from sheet "Record" to thisworkbook.
How can I identify the required workbooks (points 1 and 2)?
Thank's.
I have a folder that contains many workbooks.
I need, for any workbook:
1) check if is a .xlsm workbook;
2) if yes, check if a sheet named "Record" exists;
3) if exists, import stuff from sheet "Record" to thisworkbook.
How can I identify the required workbooks (points 1 and 2)?
Thank's.