I have been watching this thread with keen interest as it could relate to one of my macros. I've been trying to determine how to allow the user to select a directory from VBA without using VSTA or hardcoding it and generating springs from multiple files based on how they're named. Will that shellApp function do the trick or will a .BAS file need to be referenced?