Importing Based on a Partial File Name
A common task for macros is to open and process a file you want imported into your workbook. If you need to identify the import file based on a partial filename, there are a few techniques you can use. This tip discusses three of them.
Read this tip »
(Thanks to Bob Beechey, Jim Williams, Hesam Kiani, Mike Roycroft, Donald Meyerson, Gerhard Schweizer, Jacques Raubenheimer, Greg Renigar, Alex Blakenburg, David Shepherd, and Piers Morgan-Harvey for contributing to this tip.)