Export to Excel + Open Excel and resulting workbook

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,
I've read through the Export/Import pages but couldn't find an exact answer.

I'm exporting contents of forms and reports to Excel and am trying to write
code using either TransferSpreadsheet or OutputTo - not sure which is better
- and also can't figure out how to programmatically have Excel open and
display the output data. . .

Thank you tons and tons. . .

Marika :)
 
In this case, I would suggest the OutPutTo method. Look in VBA Editor Help
for complete details including the AutoStart argument.
 
Back
Top