My IT guy says I have to know what macro code does before I can use it so that I am not running malicious code. I got someone to alter it so that I can put in the Walmart calendar week into the filename. So I am trying to Google various parts of the code and I have found some useful explanations. Can you fill in the gaps? Here is what I found so far:

With Application.FileDialog(msoFileDialogFolderPicker) selects a folder from a certain path and import all the files inside it http://stackoverflow.com/questions/1...cker-using-vba

filepath = .SelectedItems(1) ' This part is involved in putting the filepath of the selected file in the variable filepath - See more at: http://lroedal.net/en/vba/read-from-....Od11itRI.dpuf or http://lroedal.net/en/vba/read-from-text-file

Set wb = Workbooks.Open - The line that starts with this text uses the file path you selected in FileDialog - http://stackoverflow.com/questions/2...-manipulate-it