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?
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?