Sandler
11-16-2017, 08:14 AM
Hi everyone,
I am looking for a VBA code that would allow me to pick a directory
(The files have the same name every month, but the folder changes every month)
then it would find the 2 files that have a specific string of text in the title (so wildcards are involved).
So for example, somewhere in the filename, it would have to have the following:
file 1: Cats-Are-Cute
file 2: Dogs-Are-Too
and merge those sheets into a new workbooks named analysis.
I am looking for a VBA code that would allow me to pick a directory
(The files have the same name every month, but the folder changes every month)
then it would find the 2 files that have a specific string of text in the title (so wildcards are involved).
So for example, somewhere in the filename, it would have to have the following:
file 1: Cats-Are-Cute
file 2: Dogs-Are-Too
and merge those sheets into a new workbooks named analysis.