I did a lot of work scripting both Excel and Access quite some time ago; I
think the basic scripting will be fine in 2000 Excel - Jordi's example is
dated 2000. XML didn't appear, I think, until the 2007 release which is
about the size of a planet and a damned pain to use. For my money the
earlier versions should be fine.
MS documentation for Excel scripting is thorough but like most of its docs,
convoluted and not so easy to find your way around. I found out most of what
I know now by trolling around the internet for examples - Google is your
friend. It's a bit tough to start but as you start to get a feel for it it
becomes pretty good. You will find many of the examples are VBA, as opposed
to VBscript. There is a difference.
Probably most of what you want to do will be simply reading and writing cell
values. That should be pretty straightforward.
> -----Original Message-----
> From: owner-xsi(at)Softimage.COM [mailto:owner-xsi(at)Softimage.COM] On
> Behalf Of Adam Seeley
> Sent: 19 April 2007 11:03
> To: XSI(at)Softimage.COM
> Subject: xsi <-> excel scripting
>
> Hi,
>
> I would like to access Excel information from within XSI to automate a
> number of things such as automatic creation of passes, partitions,
> applying materials etc.
>
> http://www.jordibares.co.uk/tutorials/com/com.html
>
> I have found Jordi's very nice description of how to do the basics but
> would like to find some more documentation about the commands available
> to use.
>
> Anyone know of a good resource with examples?
>
> I'm also using Excel 2000 which is probably a bit out of date for
> scripting/xml type stuff. Anyone know which version would be best to
> use?
>
> Many thanks,
>
> Adam.
>
>
> --
> No virus found in this outgoing message.
> Checked by AVG Free Edition.
> Version: 7.5.446 / Virus Database: 269.5.4/768 - Release Date:
> 19/04/2007 05:32
>
>
> ---
> Unsubscribe? Mail Majordomo(at)Softimage.COM with the following text in
> body:
> unsubscribe xsi
---
Unsubscribe? Mail Majordomo(at)Softimage.COM with the following text in body:
unsubscribe xsi
