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