VBA to export access to excel 1

[bdjb]

Hello,
I'm using Access XP, I need to write code to export a table to excel, while picking up a field from a query to put into the resulting file name. The query result is 0704, I need to put that into the file name, such as "0704.vapgltrans.csv". Any hints on where to start?

Thanks

What happens if you get scared half to death twice?

Bob

 

[PHV]

Have a look at the TransferSpreadsheet method for the export and at the DLookUp function to get your value.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[bdjb]

Thank you, I'll take a look at those

What happens if you get scared half to death twice?

Bob