Hi,
I created a batch macro to read all data in one folder. My batch macro only reads files with single worksheet (I also intended to read only files with one worksheet). I would like the batch macro to read through all files and tell me which files have multiple worksheets, so that I can go to them directly and delete additional worksheets. I think a combination of "filter" tool and "message" tool would do the job, but I did not figure out how yet. Maybe somebody can give me some ideas. I attached my current batch macro. Many thanks!
