Sending data in a report to an Excel template

R

Ron V

I have an Access report that I would like to extract
certain fields and have them populate fields in an Excel
template.
For example: Let's say in my Access report I have [Field
x], [Field y] & [Field z].
Now in my Excel template I just have [Field x] in Cell B3
& [Field z] in Cell B4 with their labels in A3 & A4.
How would I have the Access report export Field x & z into
their corresponding fields in the Excel template.
Is that possible?
If so, what would be the best way to go about coding it?
Could you outline how the code should look be/c I am not
that code savvy.

Thanks,
Ron
 

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