Exporting to Excel from VBA

[Maquis]

Hi there. I'm hoping someone can help me with this code. I'm sure there is a very simple way to do this, but I have not been able to find the code on my own.

I am trying set up a command button for a user to export a table (query actually). Two files need to be exported, a comma delimited text file and also an Excel file with the same format. I've coded the text file using a simple transfertext statement, but I'm stumped on the Excel export. :-I

I know how to do this by using the menus, but the menus will not be available to the users in this database.

 

[Maquis]

Ack, never mind. I just found the transferspreadsheet command. Geez, I feel stupid.

 

[CPUburn]

hi,

look under "help" in access "export excel" use the transferspreadsheet method

docmd.TransferSpreadsheet _ acExport,acSpreadsheetTypeExcel9, ...

grtz

CPU-burn