Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Throw out the Excel Object Model and then bring it back!
Hello
With the new XML model in Excel, it was time to throw out the COM interface and start creating and updating worksheets automatically using XML. However, I have quickly run into shortcomings and have not found any solution. Let's start with somthing simple, printing. After creating the worksheet with XML how can I automically print it without reverting back to COM and using the print method? Another example, calucations. Suppose I have a calculation in D4 that is the sum of B4 and C4. Let's insert values to B4 and C4 using XML, the calculation in D4 remains stale... again in COM this is not an issue. Another example, macros. With the COM interface, macros can be invoked to refine the content of a worksheet. It seems now all the macro code has to be lifted out so that similar operations can be performed through the XML model. Are there any tools out there that can help in this situation? Am I incorrect in my initial reaction? I have only been using the XML interface for a couple of days so there may be features I have missed. Peter -- www.TheReportCompany.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Throw out the Excel Object Model and then bring it back!
XML isn't a replacement for COM. It should be considered as an alternative
for a subset of the tasks that you may need to carry out. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Peter" wrote in message ... Hello With the new XML model in Excel, it was time to throw out the COM interface and start creating and updating worksheets automatically using XML. However, I have quickly run into shortcomings and have not found any solution. Let's start with somthing simple, printing. After creating the worksheet with XML how can I automically print it without reverting back to COM and using the print method? Another example, calucations. Suppose I have a calculation in D4 that is the sum of B4 and C4. Let's insert values to B4 and C4 using XML, the calculation in D4 remains stale... again in COM this is not an issue. Another example, macros. With the COM interface, macros can be invoked to refine the content of a worksheet. It seems now all the macro code has to be lifted out so that similar operations can be performed through the XML model. Are there any tools out there that can help in this situation? Am I incorrect in my initial reaction? I have only been using the XML interface for a couple of days so there may be features I have missed. Peter -- www.TheReportCompany.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Bring back .dbf in Excel | Excel Discussion (Misc queries) | |||
how do i bring back excel sheet ? | Excel Worksheet Functions | |||
Excel Object Model | Excel Programming | |||
Bring back the FORMULA RESULT BAR in excel | New Users to Excel | |||
Confusion about how the Window object fits into the Excel object model | Excel Programming |