[AccessD] Access and Excel Integration - Resources?

One of the things we used to do was to use the macro recorder to record keystrokes doing whatever 
you want to do.  Then go look at the macro which is vbE.  Now you know the syntax for whatever it 
was you did you can do that same thing from Access, or alternatively, you can just run the macro 
from Access.  Both methods have their uses.

John W. Colby
www.ColbyConsulting.com

On 7/11/2011 2:39 PM, Brad Marks wrote:
> I am doing some R&D work involving Access/Excel integration (Windows
> Automation).
>
> I just finished reading a book titled "Excel and Access Integration".
> It is a well-written book, but it does not get into a great deal of
> depth with regards to the "Automation" realm.
>
> I was wondering if there is a resource  (book or website) that covers
> this area in more depth.
>
> In a nutshell, I would like to be able to do anything that a person can
> do in "native Excel" via commands in Access 2007 which control Excel.
>
> Thanks for your help.
> Brad
>