working with multiple directories with VBA in excel

[DataMiser]

You could perhaps use a filelist box or the filesystem object for one of the directories and the dir function for the other.