Exporting Layered Custom Tables to Excel (different worksheets)

[tricia_444]

I am wondering if there is a script or syntax that can help me export a
layered Custom Table into separate Excel worksheets.  The only thing I
have found was the ExportTablesToExcelFiles script, but that exports all
my layers into ONE worksheet (each table under the other).  However, I
would like each layer to be on a separate worksheet!

Any assistance would be GREATLY appreciated!!!
Thank you!

=====================
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 K Peck]

No built-in mechanism exists for this - at least none comes to mind, but it would be a straightforward scripting task to do this work.  The table(s) would need to be specified somehow (by select status, by type, ...).  OUTPUT EXPORT provides for exporting just the top layer, so the script would bring each layer to the top, in turn, and then export it.  I don't have time right now to create this.  Perhaps someone else does.

Alternatively, write an Excel VBA script to take the individual tables on one sheet and move them to separate ones.  The ExportTablesToExcelFiles script, which is written in VBA, uses Excel automation to merge entire tables in separate Excel files into separate tabs in a single file and might be helpful as a starting point.

Regards,

Jon Peck (no "h")
Senior Software Engineer, IBM
[hidden email]
new phone: [phone]




From:        Tricia Selby <[hidden email]>
To:        [hidden email]
Date:        08/24/2011 11:59 AM
Subject:        [SPSSX-L] Exporting Layered Custom Tables to Excel (different              worksheets)
Sent by:        "SPSSX(r) Discussion" <[hidden email]>

---

I am wondering if there is a script or syntax that can help me export a
layered Custom Table into separate Excel worksheets.  The only thing I
have found was the ExportTablesToExcelFiles script, but that exports all
my layers into ONE worksheet (each table under the other).  However, I
would like each layer to be on a separate worksheet!

Any assistance would be GREATLY appreciated!!!
Thank you!

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