Buzz,
Why do you need Excel when you can make tables and graphs with Stata?
Michael Blasnik describes how to use Stata and MS Word to generate
the kind of report you seem to work on. For your information I
include the abstract of his presentation at last year's Stata Users
Group meeting in Boston.
Friedrich Huebler
Mass producing appendices using Stata and word processor mail merge
http://www.stata.com/meeting/4nasug/mblasniknasug.ppt
http://www.stata.com/meeting/4nasug/abstracts.html
Abstract: Confronted with the task of producing a large appendix to a
report that involved a page of tables and 3 graphs for each of 186
panels, the author discovered an approach to automate this process
using Stata combined with the mail-merge facilities of a word
processor. A Stata do-file produces all 558 graphs and writes an
ASCII file of data that also includes the graph file names for each
panel. A one-page mail-merge document is set up in the word
processor, and the Stata output is used as the data source to
automatically create the entire 186-page appendix with all tables and
graphs placed as desired. This session will outline how to employ
this approach for such otherwise daunting tasks.
--- Winfield Scott Burhans <[email protected]> wrote:
Roger, my hope is to use LaTex for a report set that is currently
generated from a series of Stata *.do files which create *.csv
files which
are then used as external data sources that automatically refresh
multiple
data ranges in Excel, which then are used in both tables and
graphics
generated from that data. The Excel file is printed and then
refreshed
with a new run of Stata. Currently this involves invoking Stata,
then the
Excel file, and then manually refreshing the Excel file after each
run
through the Stata *.do files. What drove me to Excel originally
was that
I needed the graphics in the report I printed, and I couldn't
figure out
an easy way to refresh the graphics in the report (this was created
several years ago). I assume I can do this in LaTex.