Seeking Book Recommendation

[Joseph Geretz]

Can you recommend a good book on Excel programming? I'm going to be
controlling Excel from the 'outside' so to speak. I'll be writing VB6 client
code to control one or more instances of Excel as automation servers. (VBA
control of Excel from the 'inside' is not important for my needs at the
present time.)

Thanks for your advice!

- Joe Geretz -

 

[Tom Ogilvy]

Probably not enough to write a book. Here are some references. Automation
from VB is the same as from Access or Word.

http://support.microsoft.com/default.aspx?scid=kb;en-us;123859
ACC: Sample OLE Automation for MS Word and MS Excel

http://support.microsoft.com/default.aspx?scid=kb;en-us;142476
Q142476 - ACC: Using Automation to Create and Manipulate an Excel Workbook

http://support.microsoft.com/default.aspx?scid=kb;en-us;184273
ACC97: How to Use Automation to Create a Microsoft Excel Chart

http://support.microsoft.com/default.aspx?scid=kb;en-us;129304
ACC: Using Automation to Transfer Data to Microsoft Excel

http://support.microsoft.com/default.aspx?scid=kb;en-us;260410
Microsoft Office 2000 automation Help file is available in the Download
Center

http://support.microsoft.com/default.aspx?scid=kb;en-us;167223
OFF97: Microsoft Office 97 Automation Help File Available


http://support.microsoft.com/support/OfficeDev/offdevinapps.asp
Programming Office from Within Office

http://support.microsoft.com/default.aspx?scid=kb;en-us;219151
Q219151 - HOWTO: Automate Excel 97 and Excel 2000 from Visual Basic

http://support.microsoft.com/support/excel/content/Automation/automation.asp
Using Automation with Microsoft Excel 97

hhttp://support.microsoft.com/default.aspx?scid=kb;en-us;170745
XL97: How to Create PivotTable from Word

http://support.microsoft.com/?kbid=177760
VBA: How to Run Macros in Other Office Programs

http://support.microsoft.com/default.aspx?scid=kb;EN-US;244167
INFO: Writing Automation Clients for Multiple Office Versions

http://support.microsoft.com/default.aspx?scid=kb;en-us;245115
INFO: Using Early Binding and Late Binding in Automation

http://support.microsoft.com/default.aspx?scid=kb;en-us;247579
INFO: Use DISPID Binding to Automate Office Applications Whenever Possible

 

[Joseph Geretz]

Hi Tom,

What I'm primarily interested in is a comprehensive documentation of the
entire object model; it's classes properties and methods. From my
perspective, it's quite a complex hierarchy Application, Workbook,
Worksheet, ActiveSheet, Cells, Ranges, CommandBars, Events, etc, etc, etc.
Hasn't anyone written a book on this?

Thanks!

- Joe Geretz -