Export to specific cells in Excel template from ACCESS

  • Thread starter mls via AccessMonster.com
  • Start date
M

mls via AccessMonster.com

I am planning to export my access table to an excel template R19 to R50 and
C1: C8. Is there a way to do this using VBA?


Thanks
 
C

cmledbetter

I am no expert but dealing with current problem very similar and this link to
article written by Doug Steele may be just the answer you are looking for.

http://www.accessmvp.com/DJSteele/SmartAccess.html

July 2005: Excelling automatically.

This will download zip file explain sample db that shows code for multiple
ways to interact with access to excel
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top