Export Access 2010Query to Excel 2010 Template

[bdavis6290]

I'm trying to export a query via VBA in Access 2010 to a pre-formatted Excel 2010 spreadsheet that is located in a folder within my documents. The Excel template and the Access query headings match each other. I attached a screen shot of the query. Thank you in advance for any help you can provide.

 

[gblack]

I am not sure what your pre-formated template looks like, but what I would do is export the query to Excel using docmd.transferspreasheet, then programatically format your excel spreadsheet, from the MS Access VBA... That way the format will always be the same but allow for changes in record counts and such.

 

[bdavis6290]

I will try it and post the results. I attached a screenshot of my Excel template. If you come up with anything that may help please post. Thank you!