Export to excel

[AndyShuter]

I've racked my brains to try & solve this one, but am afraid I am now stuck!

I have a query (qryLog4) that I would like to export into excel, but would like the user to specify the spreadsheet name & location as to where it should be saved.

Any suggestions pls?

Thanks

Andy

 

[yhgtbfk]

I've racked my brains to try & solve this one, but am afraid I am now stuck!

I have a query (qryLog4) that I would like to export into excel, but would like the user to specify the spreadsheet name & location as to where it should be saved.

Any suggestions pls?

Thanks

Andy

Open up access
Open an existing file
Select your file and select open Exclusive
Right click your table and select export
Select excel, select your location, and type whatever name you wish

 

[AndyShuter]

Sorry, didnt explain in ful!!!

I would like to drive this operation in Code

Thanks!

 

[Ron_dK]

Andy,
Take a look at this, it might give you a hint.

http://www.access-programmers.co.uk/forums/showthread.php?t=73141&highlight=export+excel+vba

http://www.access-programmers.co.uk/forums/showthread.php?t=77587&highlight=export+excel+vba