Thanks for the advice guys, seems quite straight forward once you find the actual commands you need!
Adam.
> -----Original Message-----
> From: owner-xsi(at)Softimage.COM
> [mailto:owner-xsi(at)Softimage.COM]On Behalf
> Of Kim Aldis
> Sent: 19 April 2007 11:34
> To: XSI(at)Softimage.COM
> Subject: RE: xsi <-> excel scripting
>
>
> 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
>
> ______________________________________________________________________
> This email has been scanned by the MessageLabs Email Security System.
> For more information please visit http://www.messagelabs.com/email
> ______________________________________________________________________
>
> --
> No virus found in this incoming message.
> Checked by AVG Free Edition.
> Version: 7.5.446 / Virus Database: 269.5.4/768 - Release
> Date: 19/04/2007 05:32
>
>
--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.446 / Virus Database: 269.5.5/769 - Release Date: 19/04/2007 17:56
---
Unsubscribe? Mail Majordomo(at)Softimage.COM with the following text in body:
unsubscribe xsi
