More attractive and professional outings.

[Javier Figueroa]

Hello experts from SPSS,

I have a concern and I would like to know if you can help me with this, I will be very grateful for any suggestions.

I would like my outings to be more showy, I would like to include an index and to be separated by pages in excel, this could be done in spss.

Thank you very much for your comments.

Sincerely,

--

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

[Jon Peck]

There isn't anything exactly like what you are asking for, but you can come close.

First, use OUTPUT MODIFY to add an index number to each item or use the SPSSINC MODIFY OUTPUT extension command, which has more options for the sequence numbers, to do this.

Then run the ExportWAllLayers.wwd Basic script to export all, allvisible, or selected tables to an Excel file.  Each output object gets its own tab.

This script only exports tables - no graphics.

The script is on the old SPSS Community website but may be hard to find, but I can send it to you if you want to try this.

On Wed, Oct 10, 2018 at 12:07 PM Javier Figueroa <[hidden email]> wrote:

Hello experts from SPSS,

I have a concern and I would like to know if you can help me with this, I will be very grateful for any suggestions.

I would like my outings to be more showy, I would like to include an index and to be separated by pages in excel, this could be done in spss.

Thank you very much for your comments.

Sincerely,

--

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

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

[Ki Park]

Jon,

If the tables have been created in CTABLES, and used a "colored" table
template with .stt format while creating outputs, are these will be exported
with their formats?

Ki





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

[Jon Peck]

The formatting should come over, but because Excel and Statistics use different color palettes, some colors may change.  Basic colors generally map correctly, but some more complex ones might produce surprises.

On Wed, Oct 10, 2018 at 2:06 PM Ki Park <[hidden email]> wrote:

Jon,

If the tables have been created in CTABLES, and used a "colored" table
template with .stt format while creating outputs, are these will be exported
with their formats?

Ki





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

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