E
Ernie
I could be wrong (and if so, should be lashed with a wet
noodle), but I believe that the "TransferSpreadsheet"
function has an option to transfer multiple sheets from a
single workbook just by naming them.
There's an example somewhere in this forum that shows how
to do it.
HTH
noodle), but I believe that the "TransferSpreadsheet"
function has an option to transfer multiple sheets from a
single workbook just by naming them.
There's an example somewhere in this forum that shows how
to do it.
HTH