Private Type BROWSEINFO ' used by the function GetFolderName
' dialogs, but these functions will provide a reference to a system DLL ' Excel and VBA do not provide any convenient directory chooser or file chooser Here is one that will give you a visual file chooser to pick the folder you want to save the files to and also lets you choose the CSV delimiter (I use pipes '|' because my fields contain commas and I don't want to deal with quotes): ' - Directory Choosing Helper Functions.