Applescript chart creation in Excel

[justo]

Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel Is there any example scripts for developing charts. the 2008 excel applescript referance is very, very short on example script and most of the
one's that are given as examples are not revalent to creating a working
script. There like apples on a tree, what good are they if you can't taste
them.
The one chart script referred to in MT's pub of 4/2007 is great for beginners and old L.dy', but where do you go to kick it up a notch!

 

[John McGhie]

To Automate Excel, you really need a good understanding of the Excel
Document Object Model.

That is documented in the VBA Help, which is not present in Excel 2008.

You can get it here:
http://msdn.microsoft.com/en-us/library/wss56bz7(VS.80).aspx

The examples are provided in both VBA and C#.

Ignore the statement "Because the data in an Excel document is highly
structured, the object model is hierarchical and straightforward." It's a
lie Only mutants can understand the Excel object model. But until you
do, you will never be able to code to it

Once you do understand the object model, you should have no great difficulty
in understanding the AppleScript Dictionary for Excel, which simply exposes
the same object model in Excel.

There: That's kicking it all the way into goal

Cheers

Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel
Is there any example scripts for developing charts. the 2008 excel applescript
referance is very, very short on example script and most of the
one's that are given as examples are not revalent to creating a working
script. There like apples on a tree, what good are they if you can't taste
them.
The one chart script referred to in MT's pub of 4/2007 is great for beginners
and old L.dy', but where do you go to kick it up a notch!

This email is my business email -- Please do not email me about forum
matters unless you intend to pay!