SPSSX Discussion

Spss script compatibility with Excel 2007

Classic

List

Threaded

8 messages Options

Rita Clivio

Spss script compatibility with Excel 2007

Dear Listers

I come again with my problem hoping someone could help me.

On my PC has been installed Windows 2007 and the script to export and group
tables in excel (Export tables to a single sheet) doesn’t work again.

I receive the message “Don’t find ActiveX automation (?)”.

I tried to disable the “ActiveX protection” by excel settings but without
results (I got same error message …).

The script was posted by K.Asselberghs in 2002 and Raynald added it to his
wonderful site.

Please, has anyone idea on know how to solve this ?

Thanks in advance for your help & patience

Rita

No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.487 / Virus Database: 269.13.18/1007 - Release Date: 13/09/2007
21.48

Albert-Jan Roskam

syntax to assign temp dir

Hi dear listers,

I am looking for a syntax to change the SPSS temporary
directory. I looked under SET but I can't find such a
command there.

I only have a measly 3Gb on my local harddisk, and for
some database queries this means I cannot use the
CACHE command, which makes all subsequent commands
slower. I used the GUI to change the temp dir to a
network location, but I'm assuming that working
locally is -whenever possible- is still faster. So
it's nice to be able to alter the temp dir in a
session-based way.

Thanks in advance for your replies!

Albert-Jan

Cheers!
Albert-Jan

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Did you know that 87.166253% of all statistics claim a precision of results that is not justified by the method employed? [HELMUT RICHTER]
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

____________________________________________________________________________________
Building a website is a piece of cake. Yahoo! Small Business gives you all the tools to get online.
http://smallbusiness.yahoo.com/webhosting

Oliver, Richard

Re: syntax to assign temp dir

There is no SPSS syntax command to change the temp directory, but you could try using the the environment variable SPSSTEMPDIR. In a command syntax job you could set this environment variable with the HOST command.

________________________________

From: SPSSX(r) Discussion on behalf of Albert-jan Roskam
Sent: Fri 9/14/2007 2:50 AM
To: [hidden email]
Subject: syntax to assign temp dir

Hi dear listers,

I am looking for a syntax to change the SPSS temporary
directory. I looked under SET but I can't find such a
command there.

I only have a measly 3Gb on my local harddisk, and for
some database queries this means I cannot use the
CACHE command, which makes all subsequent commands
slower. I used the GUI to change the temp dir to a
network location, but I'm assuming that working
locally is -whenever possible- is still faster. So
it's nice to be able to alter the temp dir in a
session-based way.

Thanks in advance for your replies!

Albert-Jan

Cheers!
Albert-Jan

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Did you know that 87.166253% of all statistics claim a precision of results that is not justified by the method employed? [HELMUT RICHTER]
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

____________________________________________________________________________________
Building a website is a piece of cake. Yahoo! Small Business gives you all the tools to get online.
http://smallbusiness.yahoo.com/webhosting

Fry, Jonathan B.

Re: syntax to assign temp dir

In reply to this post by Albert-Jan Roskam

There is no syntax to set the temp directory. Files are written to the temp directory during startup, before any commands can be read, so implementing such syntax would be a bit complicated. Sorry.

Jonathan Fry
SPSS Inc.

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Albert-jan Roskam
Sent: Friday, September 14, 2007 2:51 AM
To: [hidden email]
Subject: syntax to assign temp dir

Hi dear listers,

I am looking for a syntax to change the SPSS temporary
directory. I looked under SET but I can't find such a
command there.

I only have a measly 3Gb on my local harddisk, and for
some database queries this means I cannot use the
CACHE command, which makes all subsequent commands
slower. I used the GUI to change the temp dir to a
network location, but I'm assuming that working
locally is -whenever possible- is still faster. So
it's nice to be able to alter the temp dir in a
session-based way.

Thanks in advance for your replies!

Albert-Jan

Cheers!
Albert-Jan

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Did you know that 87.166253% of all statistics claim a precision of results that is not justified by the method employed? [HELMUT RICHTER]
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

____________________________________________________________________________________
Building a website is a piece of cake. Yahoo! Small Business gives you all the tools to get online.
http://smallbusiness.yahoo.com/webhosting

ViAnn Beadle

Re: syntax to assign temp dir

In reply to this post by Albert-Jan Roskam

Warning--this is an extremely geeky solution and you need to be really
careful!

The temporary location is stored in the registry so you might be able to
create a bat file to update the registry.

Dregedit.exe is a utility provided within the SPSS install directory to
update the registry. There are numerous bat files in the directory which use
it--take a look at them.

The key is Tempdir in Computer\HKEY_CURRENT_USER\Software\SPSS\SPSS for
Windows\15.0\Spsswin for SPSS 15. Search for Tempdir using regedit if you
don't have 15.0.

Based upon some other bat files, it looks to me that copying a bat file such
wmf-off.at and modifying it might work. Use dregedit/? From the console
window to get help on the arguments. Enclose the existing directory argument
in quotes.

If the directory doesn't exist, I expect that SPSS will quit with an error
message the first time it tries to write to it.

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of
Albert-jan Roskam
Sent: Friday, September 14, 2007 1:51 AM
To: [hidden email]
Subject: syntax to assign temp dir

Hi dear listers,

I am looking for a syntax to change the SPSS temporary
directory. I looked under SET but I can't find such a
command there.

I only have a measly 3Gb on my local harddisk, and for
some database queries this means I cannot use the
CACHE command, which makes all subsequent commands
slower. I used the GUI to change the temp dir to a
network location, but I'm assuming that working
locally is -whenever possible- is still faster. So
it's nice to be able to alter the temp dir in a
session-based way.

Thanks in advance for your replies!

Albert-Jan

Cheers!
Albert-Jan

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Did you know that 87.166253% of all statistics claim a precision of results
that is not justified by the method employed? [HELMUT RICHTER]
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

____________________________________________________________________________
________
Building a website is a piece of cake. Yahoo! Small Business gives you all
the tools to get online.
http://smallbusiness.yahoo.com/webhosting

Richard Ristow

Re: syntax to assign temp dir

At 11:47 AM 9/14/2007, ViAnn Beadle wrote:

>If the directory doesn't exist, I expect that SPSS will quit with an
>error message the first time it tries to write to it.

Possibly, including in the .BAT code like this will help, by creating
the specified directory if it doesn't exist. This is, obviously, a
snippet from another .BAT file.

IF EXIST %Back_Prn%\%Back_Dir%\NUL GOTO Go_Ahead
REM ................................................................
REM Test and message when subdirectory specified must be created
:MAKE_DIR
ECHO Subdirectory %Back_Prn%\%Back_Dir% will be created
MKDIR %Back_Prn%\%Back_Dir%
IF EXIST %Back_Prn%\%Back_Dir%\NUL GOTO Go_Ahead
ECHO Can neither find nor create directory %Back_Prn%\%Back_Dir%
GOTO Abort

:Go_Ahead
[[substantive code]]

:Abort
[[end of .BAT file]]

Albert-Jan Roskam

Re: syntax to assign temp dir

In reply to this post by ViAnn Beadle

Thanks Richard, ViAnn and Jonathan!

I will have a look if I could somehow accomplish this
task even though it may be doubtful that it can be
done. I am really hoping that those BAT files are the
key. If so, I'd try to follow the following strategy:
(1) modify the contents of the default BAT, such that
it uses the alternative temp dir (and make a copy of
the orginal BAT).
(2) fire up another SPSS instance using the HOST
command; this instance now uses the modified BAT.
(something similar can be done in SAS, let's see if
SPSS can also do this).
(3) rename the original/modified BAT to bring things
back to a normal configuration

Let's see... I must say that I don't feel confident
enough to tinker with the registry, just because I
don;t have enough knowledge about it.

Thanks again!

Albert-Jan

--- ViAnn Beadle <[hidden email]> wrote:

> Warning--this is an extremely geeky solution and you
> need to be really
> careful!
>
> The temporary location is stored in the registry so
> you might be able to
> create a bat file to update the registry.
>
> Dregedit.exe is a utility provided within the SPSS
> install directory to
> update the registry. There are numerous bat files in
> the directory which use
> it--take a look at them.
>
> The key is Tempdir in
> Computer\HKEY_CURRENT_USER\Software\SPSS\SPSS for
> Windows\15.0\Spsswin for SPSS 15. Search for Tempdir
> using regedit if you
> don't have 15.0.
>
> Based upon some other bat files, it looks to me that
> copying a bat file such
> wmf-off.at and modifying it might work. Use
> dregedit/? From the console
> window to get help on the arguments. Enclose the
> existing directory argument
> in quotes.
>
> If the directory doesn't exist, I expect that SPSS
> will quit with an error
> message the first time it tries to write to it.
>
> -----Original Message-----
> From: SPSSX(r) Discussion
> [mailto:[hidden email]] On Behalf Of
> Albert-jan Roskam
> Sent: Friday, September 14, 2007 1:51 AM
> To: [hidden email]
> Subject: syntax to assign temp dir
>
> Hi dear listers,
>
> I am looking for a syntax to change the SPSS
> temporary
> directory. I looked under SET but I can't find such
> a
> command there.
>
> I only have a measly 3Gb on my local harddisk, and
> for
> some database queries this means I cannot use the
> CACHE command, which makes all subsequent commands
> slower. I used the GUI to change the temp dir to a
> network location, but I'm assuming that working
> locally is -whenever possible- is still faster. So
> it's nice to be able to alter the temp dir in a
> session-based way.
>
> Thanks in advance for your replies!
>
> Albert-Jan
>
> Cheers!
> Albert-Jan
>
>

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> Did you know that 87.166253% of all statistics claim
> a precision of results
> that is not justified by the method employed?
> [HELMUT RICHTER]
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>
>
>
>
____________________________________________________________________________
> ________
> Building a website is a piece of cake. Yahoo! Small
> Business gives you all
> the tools to get online.
> http://smallbusiness.yahoo.com/webhosting
>

Cheers!
Albert-Jan

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Did you know that 87.166253% of all statistics claim a precision of results that is not justified by the method employed? [HELMUT RICHTER]
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

____________________________________________________________________________________
Building a website is a piece of cake. Yahoo! Small Business gives you all the tools to get online.
http://smallbusiness.yahoo.com/webhosting

Peck, Jon

Re: syntax to assign temp dir

You can set an environment variable with the SET command in batch syntax for the duration of that bat file run, or you can set one permanently via the Control Panel/System/Advanced dialog.

If you use the HOST command, remember that when HOST terminates, any environment variables you set that way will disappear.

HTH,
Jon Peck

-----Original Message-----
From: SPSSX(r) Discussion on behalf of Albert-jan Roskam
Sent: Sat 9/15/2007 12:24 PM
To: [hidden email]
Subject: Re: [SPSSX-L] syntax to assign temp dir

Thanks Richard, ViAnn and Jonathan!

I will have a look if I could somehow accomplish this
task even though it may be doubtful that it can be
done. I am really hoping that those BAT files are the
key. If so, I'd try to follow the following strategy:
(1) modify the contents of the default BAT, such that
it uses the alternative temp dir (and make a copy of
the orginal BAT).
(2) fire up another SPSS instance using the HOST
command; this instance now uses the modified BAT.
(something similar can be done in SAS, let's see if
SPSS can also do this).
(3) rename the original/modified BAT to bring things
back to a normal configuration

Let's see... I must say that I don't feel confident
enough to tinker with the registry, just because I
don;t have enough knowledge about it.

Thanks again!

Albert-Jan

--- ViAnn Beadle <[hidden email]> wrote: