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!!!!!!!!