I have briefed both DoCmd.TransferSpreadsheet and DoCmd.OutputTo. Both have their strengths and their purpose.
DoCmd.OutputTo Method is great if one is transferring a single Table or Query to a spreadsheet. However, I need to export several Tables to different worksheets in the same Excel file. This is easily done using the DoCmd.TransferSpreadsheet method. There is, however, one small problem.
It would appear that the DoCmd.TransferSpreadsheet method does not offer the 'Save Formatted' option whereas the DoCmd.OutputTo option does.
Other than using a considerable amount of code to actually open up the Excel file and adjust the formatting, is there another method/parameter so that the DoCmd.TransferSpreadsheet method exports the formatting as well?
Thanks for the help.
Pat
DoCmd.OutputTo Method is great if one is transferring a single Table or Query to a spreadsheet. However, I need to export several Tables to different worksheets in the same Excel file. This is easily done using the DoCmd.TransferSpreadsheet method. There is, however, one small problem.
It would appear that the DoCmd.TransferSpreadsheet method does not offer the 'Save Formatted' option whereas the DoCmd.OutputTo option does.
Other than using a considerable amount of code to actually open up the Excel file and adjust the formatting, is there another method/parameter so that the DoCmd.TransferSpreadsheet method exports the formatting as well?
Thanks for the help.
Pat
