Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.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 - |
#2
Posted to microsoft.public.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...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 - |
#3
Posted to microsoft.public.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 - "Tom Ogilvy" wrote in message ... 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 - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Book recommendation | New Users to Excel | |||
Book Recommendation | Excel Discussion (Misc queries) | |||
Book Recommendation?? | Excel Programming | |||
Excel programming book recommendation | Excel Programming | |||
Excel VBA programming book recommendation? | Excel Programming |