|
|
How can change autoformat for my specified
table formatation in SPSS.
Sub ExcelMacro()
objExcelApp.Selection.AutoFormat
Format:=&H14, Number:=False, _
Font:=False, Alignment:=True,
Border:=False, Pattern:=True, Width:=True
MsgBox "The name
of the active sheet is " & objExcelApp.ActiveSheet.Name
End Sub
----- Forwarded by Juris
Breidaks/CSB/LV on 06.02.2009 10:03 -----
| "Peck, Jon" <[hidden email]>
05.02.2009 20:13
|
|
To
| "Juris Breidaks" <[hidden email]>,
|
|
cc
|
|
|
Subject
| RE: [SPSSX-L] many
tables in SPSS output to xls worksheet |
|
You can find a Basic script
for this on Developer Central (www.spss.com/devcentral)
in the Downloads section. It prompts you in a dialog for the specification
and creates either separate Excel files for each table or makes them separate
sheets in one file.
Look for Excel Export.
It is helpful to click "Single-Page View" at the top of
the list.
HTH,
Jon Peck
From: SPSSX(r) Discussion [mailto:[hidden email]]
On Behalf Of Juris Breidaks
Sent: Thursday, February 05, 2009 6:38 AM
To: [hidden email]
Subject: [SPSSX-L] many tables in SPSS output to xls worksheet
Hello,
I have many tables in SPSS output. How can I save all this tables in one
book, but in different worksheets!
Juris
|
Locked
