My question pertains to both MS Access and MS Excel. I understand that
this is an Excel newsgroup, but I can't seem to find any solutions in
the Access programming newsgroups so I though I would try here for
someone who has used these programs in tandem.

I am using Access to query for information related to project work
activities. Because there are multiple activities for each project, I
want to generate a histogram of the production rates for each activity.


To do this, I am exporting my data from Access to Excel (b/c I find
Excel much better at manipulating data, and I'm trying to stay
consistent with a few other sets of charts I'm generating).

Unfortunately, I'm running into problems with the Analysis Toolpak. My
code gets hungup on the following line:

xlApp.Run "C:\Program Files\Microsoft
Office\OFFICE11\Library\Analysis\ATPVBAEN.XLA!Hist ogram", ItemRange,
"", False, True, True, True

The error says the macro cannot be found. Does anyone have any
experience with this? Any and all help is much appreciated. Thanks in
advance!

Rob