Quick question, what command do you use to copy multiple files in an Excel macro? I'd like top copy *.xlsx from one folder to another but FileCopy command is giving me "Bad file name or number"
I can provide the FileCopy command if this is supposed to work. Or should I be using another command?
Bookmarks