Export to Excel + Open Excel and resulting workbook

[marika1981]

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

 

[Klatuu]

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