G
Guest
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 similar to the "Save
Formatted" feature?
Thanks for the help.
Pat
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 similar to the "Save
Formatted" feature?
Thanks for the help.
Pat