Edit XLS output from SendObject method?

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

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
 
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"
 
Back
Top