Export To Excel in one shot

[Guest]

Is there a command to export a table to excel in one shot with VBA?
I know how to do it with DAO, running through an entire recordset populating
cells based on a where clause and whatnot. But whatabout a simpler method thats
faster?


(e-mail address removed)

 

[Ken Snell [MVP]]

TransferSpreadsheet is what you seek. It's in Help files.

 

[Guest]

Thanks. I'll check that out.


(e-mail address removed)