Transpose Table Rows and Columns In SPSS 17 (PASW)

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

Transpose Table Rows and Columns In SPSS 17 (PASW)

Joseph Schneider
All,

My usual method of using a script to transpose tabe rows and columns prior
to export to excel is not working in version 17.

Here is what worked in v16 from SPSS website:

objTable.PivotManager.TransposeRowsWithColumns

It is not working in v17. Any suggestions? The error is expecting existing
Scalar Variable.

If I use
Dim objPivotMgr As ISpssPivotMgr
Set objPivotMgr = objTable.PivotManager
objPivotMgr.TransposeRowsWithColumns

Same error.

Joe

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