Re: st: AW: How to get Stata 10 to export formatted tables to microsoft word or excel?

[SCHOUMAKER Bruno <bruno.schoumaker@uclouvain.be>]

- Tabout - is also very flexible and allows you to save tables as .csv 
files (but no regression results I think). You can then open the file 
directly from in excel, and use a simple macro to convert file  If you 
have many files, it is also possible to write a visual basic script as 
part of your stata program, and run you VB script from excel.
Bruno



Le 5/08/2010 14:46, Martin Weiss a écrit :
> <>
>
> You should definitely take a look at the -estout- suite of commands
> (user-written), which you can obtain from
>
> *************
> ssc d estout
> *************
>
>
>
> HTH
> Martin
>
>
> -----Ursprüngliche Nachricht-----
> Von: owner-statalist@hsphsun2.harvard.edu
> [mailto:owner-statalist@hsphsun2.harvard.edu] Im Auftrag von Faiz Rasool
> Gesendet: Donnerstag, 5. August 2010 14:33
> An: statalist@hsphsun2.harvard.edu
> Betreff: st: How to get Stata 10 to export formatted tables to microsoft
> word or excel?
>
> Hi all:
>
> I'm new to Stata and to this email list. I'm a Blind student. I'm interested
>
> to find out the ways of exporting tables to Microsoft word or excel in a way
>
> that requires little manual formatting specially formatting that involves a
> use of mouse. The information I've search on the internet regarding tables
> produced by stata and moving them to word has largely suggested that 1
> select the table in the results window, 2 select remove  | from the table
> copy option, 3 paste it to a word processor of choice. Their are two basic
> issues with this approach that do not allow me to follow it. 1 The table can
>
> only be highlighted using a mouse. 2 The screen reading software that I use
> does not read the contents of the results window,  it works fine with  menus
>
> and variables window though. Presently I've to  coppy the entire results
> window and paste it into microsoft word. Using this approach tables are not
> at all formatted and I've to coppy and paste after every command to see what
>
> is its output. Ideally I'd like that their is an option that lets me export
> tables in formatted form, or require little input from a mouse in formatting
>
> them. By tables I'm refering to all forms of tables from summary statistics
> to regression results. I'm sorry if it is not allowed to mention SPSS here.
> But it does do what I've requested above. I Wish Stata has this facility
> too.
>
> Thanks all,
> Faiz.
>
> *
> *   For searches and help try:
> *   http://www.stata.com/help.cgi?search
> *   http://www.stata.com/support/statalist/faq
> *   http://www.ats.ucla.edu/stat/stata/
>
>
> *
> *   For searches and help try:
> *   http://www.stata.com/help.cgi?search
> *   http://www.stata.com/support/statalist/faq
> *   http://www.ats.ucla.edu/stat/stata/
>    


--
Bruno SCHOUMAKER

Centre de recherche en démographie et sociétés
Université catholique de Louvain
1-17 PLace Montesquieu
1348 Louvain-la-Neuve
BELGIUM

Tel. +32 10 474136
Fax. +32 10 472952

bruno.schoumaker@uclouvain.be
www.uclouvain.be/demo

*
*   For searches and help try:
*   http://www.stata.com/help.cgi?search
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/