Thomas Bryant

traverse directory parts with excel tie in

Discussion created by Thomas Bryant on Apr 14, 2016
Latest reply on Apr 15, 2016 by Thomas Bryant
Branched from an earlier discussion

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?

Outcomes