Export query results and overwrite existing xls file data

[solsearcher]

I have an xls file with macros embedded that needs updating on a daily basis. The data I need to update this sheet is in an Access database table. I have created a select query to obtain the correct data to be exported but that's about my limit.
It would be a great help if somebody could steer me in the right direction.

 

[boblarson]

See if this helps:

http://www.btabdevelopment.com/ts/tq2xlspecwspath