M
MimiSD
Is there a way for me to run the TransferSpreadsheet macro then have it
automatically pull up the file in excel once the data has been exported? I
like the way that OutputTo works but it only allows me to have one worksheet.
The transferSpreadsheet allows me to input two different worksheets in the
workbook. Do i need to do some VB coding in order to accomplish this? If
so, what code do i need?
automatically pull up the file in excel once the data has been exported? I
like the way that OutputTo works but it only allows me to have one worksheet.
The transferSpreadsheet allows me to input two different worksheets in the
workbook. Do i need to do some VB coding in order to accomplish this? If
so, what code do i need?