Output to Excel Question

[P-chu via AccessMonster.com]

I need to output my list box results in a form to exce without creating a
query to do it. Could someone critique this or give me another sample?


DoCmd.OutputTo acQuery, ([Forms]![customers]), acFormatXLS, "*.xls", True

The list box name is lstCust and it is new customer information based on
selected dates. I'm sure I am just missing something very minor.

Thanks.

 

[akphidelt]

Not sure if you can send a list box like that, but it would be extremely easy
to output a query that creates the listbox to excel.

 

[P-chu via AccessMonster.com]

I got it figured out. Thanks anyway.

Not sure if you can send a list box like that, but it would be extremely easy
to output a query that creates the listbox to excel.

I need to output my list box results in a form to exce without creating a
query to do it. Could someone critique this or give me another sample?

[quoted text clipped - 5 lines]

Thanks.