INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Member Login

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips now!

Talk With Other Members
Be Notified Of Responses
To Your Posts
Keyword Search
One-Click Access To Your
Favorite Forums
Automated Signatures
On Your Posts
Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

LINK TO THIS FORUM!

Tek-Tips LinkedIn^® Group

Join our
LinkedIn^® Group!

Hook up with past and present colleagues and classmates quickly.

Partner With Us!

"Best Of Breed" Forums Add Stickiness To Your Site

(Download This Button Today!)

Feedback

"...I love this site! It's so nice to know that there are so many people out there who are willing to share their knowledge..."

More...

Geography

Where in the world do Tek-Tips members come from?

Click Here To Find Out!

Tek-Tips Shirts!

Get your
Tek-Tips Forums
SWAG here!

Home > Forums > Enterprise Applications > ERP and CRM Solution Vendors > SPSS solutions Forum

Export SPSS table to Word

Read More Threads Like This One

netcashin (Programmer)

29 Nov 01 16:31

We are trying to automate the transfer of SPSS tables to a word document, but are having trouble doing it. Any suggestions would be helpful.

Thanks

Hoef (TechnicalUser)

5 Dec 01 5:46

In the Output-SPSS window: right click the table and CopyObjects. In Word: Paste, that's all (at least that;s how it easily works in SPSS for Windows V10)

netcashin (Programmer)

5 Dec 01 12:18

Hoef

We have been able to do that, but I am looking for a way to automate it through VBA code, so that it will copy a number of tables (263 tables) to word.

thanks

Sideline (TechnicalUser)

15 Aug 02 20:38

netcashin,

Did you sort automating the export of the SPSS tables?

Curious how you did it.

thanks

Piperp (TechnicalUser)

4 Sep 02 16:23

Try this link...if this page doesn't have what you need my guess is it will be somewhere on the site. This guy is awesome.

P

http://pages.infinit.net/rlevesqu/SampleScripts.htm#ImportExport

Sideline (TechnicalUser)

5 Sep 02 5:53

Piperp,
Thanks for the link. I too have used Ray's site and it is very useful. I was more curious about the logic that netcashin used is in, I presume, creating and exporting the tables to Word. I have a process that creates, expand, modifies, then exports OLAP cubes to excel but I am having trouble figuring out how to place the exported cubes into different excel worksheets.

MRuser (TechnicalUser)

12 May 04 20:38

If I am understanding you correctly, all you need to do in the Output file is go to:

Edit/ Select/ All Pivot Tables.

Then

File/ Export/

* Selected files
* Word/RTF file

This will spit out everthing in your output file nice and clean.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Back To Forum

Back To SPSS solutions