Seeking Book Recommendation  
Author Message
FrankAm





PostPosted: 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





PostPosted: Mon Apr 10 19:32:52 CDT 2006 Top

Excel Programming >> Seeking Book Recommendation 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 -
>
>


 
 
Joseph





PostPosted: 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 -
>>
>>
>
>