Edit XLS output from SendObject method?

[Guest]

I am using the DoCmd.SendObject method to send a query in the form of an
Excel spreadsheet. How can I obtain a reference to the output file for
editing? I need to change the name of the sheet in my output file before
sending it.

Nathan

 

[Nikos Yannacopoulos]

Nathan,

You could use DoCmd.TransferSpreadsheet intead. One of the
TransferSpreadsheet arguments is Range; Access help says it is not used in
Export, but if you give it a value (string) it will name the worksheet after
it (an undocumented feature, I guess).

HTH,
Nikos

"NoSpamTakeSquareRootOfNumber"