Yaseen,
Your message implies that you have Stat/Transfer. In your do-file,
you can save the results as a Stata data file and then convert this
file with -stcmd- to an Excel file. This file could then be linked to
your other Excel files.
save results.dta, replace
stcmd stata results.dta excel results.xls /y
Friedrich Huebler
--- Yaseen Ghulam <[email protected]> wrote:
> Dear Stata users,
>
> Is there anyway of linking stata and MS Excel? I mean we run the
> model from our
> do files, do the predictions and other calculations and excel get
> the predicted
> values direcly from Stata. Our objective is to present these
> coefficents and
> predicted values in excel pivot tables. One way may be creating log
> files or
> coping and pasting or using stat transfer, but we are interested
> that excel should
> get the values in a way as it gets values from other sheets or
> excel file.
>
> Yaseen Ghulam
> Lecturer Banking and Finance
> University of Portsmouth
> Economics Department
> U.K.
__________________________________
Do you Yahoo!?
Check out the new Yahoo! Front Page.
www.yahoo.com
*
* For searches and help try:
* http://www.stata.com/support/faqs/res/findit.html
* http://www.stata.com/support/statalist/faq
* http://www.ats.ucla.edu/stat/stata/
