Name Stamp export to Excel   

Hi,

Is there a way to make the data export to excel like "Bob.xls".  Right
now, I try to test and still give me the name of the query.

Here is the line of the code:

DoCmd.SendObject acQuery, "Query", "MicrosoftExcelBiff8 *.xls)",
"learning_codes@hotmail.com", "", "", "Subject", "", False

I received my email with attachment:   Query.xls

Is there a way for me to capture from CurrentUserName (strUserID =
Me.CurrentUserName)?

I want to see Bob.xls instead of Query.xls.

Your help would be much appreciated.

Thanks

date: Sat, 4 Oct 2008 07:38:18 -0700 (PDT)   author:   unknown

Re: Name Stamp export to Excel   

Use DoCmd.TransferSpreadsheet instead of DoCmd.SendObject. You can specify 
the name of the EXCEL file with DoCmd.TransferSpreadsheet.

-- 

        Ken Snell
<MS ACCESS MVP>


 wrote in message 
news:ad05661e-d7dd-40d8-823d-083de2243826@f77g2000hsf.googlegroups.com...
> Hi,
>
> Is there a way to make the data export to excel like "Bob.xls".  Right
> now, I try to test and still give me the name of the query.
>
> Here is the line of the code:
>
> DoCmd.SendObject acQuery, "Query", "MicrosoftExcelBiff8 *.xls)",
> "learning_codes@hotmail.com", "", "", "Subject", "", False
>
> I received my email with attachment:   Query.xls
>
> Is there a way for me to capture from CurrentUserName (strUserID =
> Me.CurrentUserName)?
>
> I want to see Bob.xls instead of Query.xls.
>
> Your help would be much appreciated.
>
> Thanks

date: Sat, 4 Oct 2008 11:05:10 -0400   author:   Ken Snell \(MVP\) etl