Howdy all,

I need to know something. I have designed a macro in VBA to transfer spreadsheets, but the thing is, instead of typing out the command for each spreadsheet, is there some code that will transfer all the spreadsheets in a designated sub directory, ending with ".xlk"

Can anyone help?