Insert a new worksheet named 'listings' in all xlsx-files of a given folder
Posted on 2012-04-12
I would like to run a macro that accomplishes the following task:
Insert a worksheet named 'listings' in all files of a folder
The macro is to run from a xlsm-file that always resides in the folder where all the xlsx-files have to be worked on.
That is, the macro should work on any folder, i.e. - I guess - the code snippet 'ActiveWorkbook.path' should be part of the code.
Help is much appreciated. Thank you very much in advance.