Excel Automation from Access -- book/website?

[Guest]

All,

I'm trying to see if I can do excel Pivot table automation from Access. Now,
I've done some excel automation through Access, but everything seems like
trial and error since I really don't know the right objects and methods (took
me way too long to figure out how to insert a row in Excel thru Access!)

Can anyone recommend books and/or websites to do this sort of thing?
Something that can teach as well as be a reference?

For an example, I'm talking about coding like this
http://mvps.org/access/modules/mdl0006.htm

Thanks!
-Mark

 

[aaron.kempf]

excel is a disease

you can do pivotTables in access-- open a table in pivotTable view

if you're really an access badass you should be using Access Data
Projects; keeping all your data in SQL Server / MSDE; and then you can
use _REAL_ pivotTables.. also known as OLAP / Analysis Services

 

[matkivskij]

All,

I'm trying to see if I can do excel Pivot table automation from Access.
Now,
I've done some excel automation through Access, but everything seems like
trial and error since I really don't know the right objects and methods
(took
me way too long to figure out how to insert a row in Excel thru Access!)

Can anyone recommend books and/or websites to do this sort of thing?
Something that can teach as well as be a reference?

For an example, I'm talking about coding like this
http://mvps.org/access/modules/mdl0006.htm

Thanks!
-Mark

 

[Arvin Meyer [MVP]]

Search at Amazon.com for books by Ken Getz. There are several different
versions of the Access Developer's Handbook, The VBA Developer's Handbook,
and the Visual Basic Language Developer's Hanbook. The first and second ones
are the ones I've found most helpful. F.Scott Barker's Access Power
Programming books also have some automation examples.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access