Access Report to Exisiting Excel File

[ccoffelt]

Help! I'm new to this Access stuff. First of all, I'm using Access 2000. I created a nice report for my boss that has the following info:

WO#
Worktype
Status
equip#
Problem
Countermeasure
Resp. Person
Start Date
Finish Date

Now the hard part is I need to export this report to an existing Excel file where he has some other data that he has manually entered. I can export the data no problem to Excel by using the Publish to Excel button on the toolbar. However, I do not know how to go about getting it into an existing spreadsheet. I assume I will need to write some fancy code which by the way I have no clue how to do. Where do you even insert VBA code? Can somebody please point me in the right direction before I get fired?

Thanks