Unanswered: Creating Specific Formatted Report in Excel from Access 2000
Im currently working on a database to store the reports created from some of the intruments at work. These reports have a specific layout already in place and are conventionally stored as Excel spreadsheets as this can allow for any further processing to be carried out on them. I do not wish to alter the current report style/format and also wish for the reports created from my database to be able to have any processing to be easily applied to them, basically - I need the reports to be exported from Access into a specific format within Excel.
From reading some of the posts on this forum it would seem quite possible that by using some VBA code I could export the fields into specific cells within an Excel spreadsheet. Whilst I do have some experience with both Access and Excel (as well as VBA) I am unsure of how I can achieve my aim - can somebody help me with what code would be necessary in order to achieve this?