[AccessD] Access and Excel Integration - Resources?

Brad,

I like john's approach and sometimes use it... but don't like how the macro
recorder works in Excel 2007+.

My suggestion is to get comfortable with the basics of the Excel object
model (easier said...) and in all your access projects, in the beginning at
least, add a reference to Excel's object library. Stay away from all late
binding in the early period (before you go to production with your
application) - so you get the benefit of intellisense. Later you can change
declarations to Objects, remove the reference to Excel,  and Access will be
happy to tell you where you need to substitute numbers for intrinsic
constants.

You can also join this list
http://catalist.lsoft.com/scripts/wl.exe?SL1=EXCEL-L&H=PEACH.EASE.LSOFT.COM.
Most seasoned Listers are experienced Access programmers too.

Good luck.

Bill
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Brad Marks
Sent: Monday, July 11, 2011 2:40 PM
To: Access Developers discussion and problem solving
Subject: [AccessD] Access and Excel Integration - Resources?

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

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com