|
|
Seeking Book Recommendation |
|
Author |
Message |
FrankAm
|
Posted: Mon Apr 10 19:32:52 CDT 2006 |
Top |
Excel Programming >> Seeking Book Recommendation
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 -
Excel289
|
|
|
|
|
Tom
|
Posted: Mon Apr 10 19:32:52 CDT 2006 |
Top |
|
|
|
Joseph
|
Posted: Mon Apr 10 21:38:06 CDT 2006 |
Top |
Excel Programming >> Seeking Book Recommendation
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 -
> 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
> --
> Regards,
> Tom Ogilvy
>
>> 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 -
>>
>>
>
>
|
|
|
|
|
|
|