C
ccoffelt
Help! I'm new to this Access stuff. First of all, I'm using Access 2000. I
hope I can explain this so it makes sense. 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
Also note that when you double click on the report it ask for a Dept # then
gives the above info for that Dept.
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 that has info already in it. 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
hope I can explain this so it makes sense. 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
Also note that when you double click on the report it ask for a Dept # then
gives the above info for that Dept.
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 that has info already in it. 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