Exporting to specific spots on excel.

[sonoamore]

First off: Apologies if this is in another thread, but I didn't turn up what I needed in the search.



I'm trying to export the values from about 10 fields into specific spots in an excel report. What I need to have happen on button click:

- Open selected file (Let's just say C:\Report.xlsx) as a copy.

- Insert fields A,B,C,D,E,F,G,H from the currently open form into A1, B1, C1, D1, E1, F1, G1, H1 on Report.xlsx respectively.

I've tried a few things but honestly I'm not really getting anywhere. Any help is greatly appreciated!!!!!!!!

[ssanfu]

This is going to involve VBA.

Ken Snell has a lot of examples of Access automation with Excel.
http://www.accessmvp.com/kdsnell/EXCEL_Export.htm


I have code that exports an query using Docmd.OutputTo, then writes some formulas to specific cells, then adds formatting. I used bits and pieces of Ken's examples.