Problems with Basic scripting in Statistics version 25.

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

Problems with Basic scripting in Statistics version 25.

David Marso
Administrator
I wonder if others have experienced problems with SPSS 25 not being able to
create a reference to the SPSS COM objects using Winword Basic?
I am working with a client who has NO desire to shift to python but after
upgrading from version 13 to 25 the scripts fail on any method involving the
SPSS objects.

Weird thing is at one point my version 22 was having a similar issue.  I
downloaded the ver 25 Subscription version and suddenly my ver 22 was able
to use Basic Scripting.  My v25 subscription has expired but my v22 still
functions.

Probably some silly registry setting but who knows?



-----
Please reply to the list and not to my personal email.
Those desiring my consulting or training services please feel free to email me.
---
"Nolite dare sanctum canibus neque mittatis margaritas vestras ante porcos ne forte conculcent eas pedibus suis."
Cum es damnatorum possederunt porcos iens ut salire off sanguinum cliff in abyssum?"
--
Sent from: http://spssx-discussion.1045642.n5.nabble.com/

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (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
Please reply to the list and not to my personal email.
Those desiring my consulting or training services please feel free to email me.
---
"Nolite dare sanctum canibus neque mittatis margaritas vestras ante porcos ne forte conculcent eas pedibus suis."
Cum es damnatorum possederunt porcos iens ut salire off sanguinum cliff in abyssum?"
Reply | Threaded
Open this post in threaded view
|

Re: Problems with Basic scripting in Statistics version 25.

Bruce Weaver
Administrator
This post was updated on .
Hi David.  Scripting in basic is not my strong suit, but I do remember that
starting in v16, there was a change from Sax basic to another flavour of
Basic.  E.g., see these links:

https://www.ibm.com/support/knowledgecenter/en/SSLVMB_24.0.0/spss/base/idh_pref_scripts.html
http://www-01.ibm.com/support/docview.wss?uid=swg21480060

Could that be the source of the problem?  Or have you already dealt with
that?  

EDITED 16-Mar-2018:  Second "already" deleted from "already dealt with that already".  

David Marso wrote
> I wonder if others have experienced problems with SPSS 25 not being able
> to
> create a reference to the SPSS COM objects using Winword Basic?
> I am working with a client who has NO desire to shift to python but after
> upgrading from version 13 to 25 the scripts fail on any method involving
> the
> SPSS objects.
>
> Weird thing is at one point my version 22 was having a similar issue.  I
> downloaded the ver 25 Subscription version and suddenly my ver 22 was able
> to use Basic Scripting.  My v25 subscription has expired but my v22 still
> functions.
>
> Probably some silly registry setting but who knows?
>
>
>
> -----
> Please reply to the list and not to my personal email.
> Those desiring my consulting or training services please feel free to
> email me.
> ---
> "Nolite dare sanctum canibus neque mittatis margaritas vestras ante porcos
> ne forte conculcent eas pedibus suis."
> Cum es damnatorum possederunt porcos iens ut salire off sanguinum cliff in
> abyssum?"
> --
> Sent from: http://spssx-discussion.1045642.n5.nabble.com/
>
> =====================
> To manage your subscription to SPSSX-L, send a message to

> LISTSERV@.UGA

>  (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





-----
--
Bruce Weaver
bweaver@lakeheadu.ca
http://sites.google.com/a/lakeheadu.ca/bweaver/

"When all else fails, RTFM."

NOTE: My Hotmail account is not monitored regularly.
To send me an e-mail, please use the address shown above.

--
Sent from: http://spssx-discussion.1045642.n5.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
--
Bruce Weaver
bweaver@lakeheadu.ca
http://sites.google.com/a/lakeheadu.ca/bweaver/

"When all else fails, RTFM."

PLEASE NOTE THE FOLLOWING: 
1. My Hotmail account is not monitored regularly. To send me an e-mail, please use the address shown above.
2. The SPSSX Discussion forum on Nabble is no longer linked to the SPSSX-L listserv administered by UGA (https://listserv.uga.edu/).
Reply | Threaded
Open this post in threaded view
|

Re: Problems with Basic scripting in Statistics version 25.

David Marso
Administrator
Thanks for chiming in Bruce,
It is more than simply environment/Autoscript/Global script etc noted in
those 2 docs
He can't even get off the ground with:

'#Language "WWB-COM"

Option Explicit

Sub Main
        Debug.Print objSpssApp.CurrentDirectory
End Sub

When cycling through the statements by pressing F8, it stops and states in
the lower left of the window “(10092) ActiveX Automation: server cannot
create object.”

Odd thing is if v22 is installed as well as v25 the scripts work in v25.
Something odd in COM land.




-----
Please reply to the list and not to my personal email.
Those desiring my consulting or training services please feel free to email me.
---
"Nolite dare sanctum canibus neque mittatis margaritas vestras ante porcos ne forte conculcent eas pedibus suis."
Cum es damnatorum possederunt porcos iens ut salire off sanguinum cliff in abyssum?"
--
Sent from: http://spssx-discussion.1045642.n5.nabble.com/

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (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
Please reply to the list and not to my personal email.
Those desiring my consulting or training services please feel free to email me.
---
"Nolite dare sanctum canibus neque mittatis margaritas vestras ante porcos ne forte conculcent eas pedibus suis."
Cum es damnatorum possederunt porcos iens ut salire off sanguinum cliff in abyssum?"