Export formatted access report into excel

[555Rage]

This is a picture of my Access report http://i.imgur.com/sWXUZ.png, each of the textbox recieve its data from another textbox in a form.
This is a picture of an excel template http://i.imgur.com/79Hkd.png.



Is it possible for me to export the data in the textbox of my report into my excel template cell specifically.
I have been using Access for 1 week plus and have no experience in VBA codes or whatsoever, so please explain in "noob" terms (: Thanks!!!

[June7]

Not quite. VBA code can query the Access data and then feed data into the cells. Gets rather complicated. Especially if you want the code in Access instead of behind the Excel file.

Only one textbox?

Why use Excel?

[555Rage]

All of the text box needs to be exported to each cell in excel specifically. I need to export it to excel because my supervisor requested it that way and because its the "main" file format that everybody uses to transfer data around the company. You were saying something about a code behind the excel file? can you explain more please.

[June7]

Here is link https://www.box.com/shared/iig01rg0ut to a workbook with code that pulls data from Access db. It won't actually run for you but you can view the code. Will need to activate the Developer tab on ribbon then open the VBA editor to view the code. Some sheets are hidden but you can unhide them. It might be protected but there is no password, just hit ENTER through the password prompt.

[555Rage]

Thanks so much! I'll go take a look, if i have any questions , I'll just post it here if you dont mind (:

[chris.williams]

You can also export the raw data (not formatted) to a specific sheet in the workbook. Then you can create links in the form you want everyone to see to the actual data eg: formula in A3 would be = Sheet2!B6 (or something similar)

Unless there is a lot of data, this is an easy way to get formatting the way you want it.