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...b;en-us;123859
ACC: Sample OLE Automation for MS Word and MS Excel
http://support.microsoft.com/default...b;en-us;142476
Q142476 - ACC: Using Automation to Create and Manipulate an Excel Workbook
http://support.microsoft.com/default...b;en-us;184273
ACC97: How to Use Automation to Create a Microsoft Excel Chart
http://support.microsoft.com/default...b;en-us;129304
ACC: Using Automation to Transfer Data to Microsoft Excel
http://support.microsoft.com/default...b;en-us;260410
Microsoft Office 2000 automation Help file is available in the Download
Center
http://support.microsoft.com/default...b;en-us;167223
OFF97: Microsoft Office 97 Automation Help File Available
http://support.microsoft.com/support...fdevinapps.asp
Programming Office from Within Office
http://support.microsoft.com/default...b;en-us;219151
Q219151 - HOWTO: Automate Excel 97 and Excel 2000 from Visual Basic
http://support.microsoft.com/support...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...b;EN-US;244167
INFO: Writing Automation Clients for Multiple Office Versions
http://support.microsoft.com/default...b;en-us;245115
INFO: Using Early Binding and Late Binding in Automation
http://support.microsoft.com/default...b;en-us;247579
INFO: Use DISPID Binding to Automate Office Applications Whenever Possible
--
Regards,
Tom Ogilvy
"Joseph Geretz" wrote in message
...
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 -