I don't recall there being 2 parameters for CreateObject. GetObject Yes! Does the following work? -- Sub Test() Set spssApp = CreateObject("spsswin.Application16") End Sub

cd1001 wrote: > > Hello, > > it would be nice, if someone could give me some advice: > > 1. I'm trying to automate Spss 20 from Excel-VBA. These references are > set: > > C:\Program Files\Common Files\IBM\SPSS\COM\spsswin.tlb > C:\Program Files\Common Files\IBM\SPSS\COM\spsswin.dll > > My environment: Windows 7, Excel 2003/ Excel 2010 64bit > My Code to invoke Spss: > > '### > > Private spssApp As spsswin.Application > > Sub Test() > > Set spssApp = CreateObject("", "spsswin.Application16") > > End Sub > > '### > > I always get an Error Message: "ActiveX componente can't create object" > (Err 429) > > That happens in Excel 2003 and 2010 (64) > > Whats wrong with it? > > 2. If I try to code in the winwrap-IDE in spss itself, I don't see any > spss-specific entries in the object-catalog. The Script-Editor seems to > has lost his reference to spss - no intellisense, no recognizing of > spss-objects. What should I do? > > > 3. I'm aware, that python could be an alternative. But that would be a new > language for me. I'm hesitating because it seems the python-plugin is > based on v2.8 - and I don't want to learn something obsolete in the first > place. My questions: Does the plugin work wit python 3.x too? Are there > any good reasons to begin with an older version of python? > > > Any help appreciated. Thanks. > > > Chris Drontheim > Berlin >

-- View this message in context: http://spssx-discussion.1045642.n5.nabble.com/v20-Programming-Setup-external-Sax-Basic-Python-tp4980953p4981009.html Sent from the SPSSX Discussion mailing list archive at Nabble.com.

===================== To manage your subscription to SPSSX-L, send a message to LISTSERV@LISTSERV.UGA.EDU (not to SPSSX-L), with no body text except the command. To leave the list, send the command SIGNOFF SPSSX-L For a list of commands to manage subscriptions, send the command INFO REFCARD