Statalist The Stata Listserver


[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]

st: RE: RE: DLL for Stata to facilitate integration of Stata programs with MS Excel Visual Basic


From   "McKenna, Timothy" <Timothy.McKenna@NERA.com>
To   <statalist@hsphsun2.harvard.edu>
Subject   st: RE: RE: DLL for Stata to facilitate integration of Stata programs with MS Excel Visual Basic
Date   Wed, 14 Feb 2007 17:32:59 -0500

I don't know much about VBA, but can't you get VBA to issue commands via
the command prompt?  Then you can call Stata in batch mode, have it run
a do file, and then get VBA to read the results (likely stored in a .csv
file).

See:
http://www.stata.com/support/faqs/win/batch.html

-----Original Message-----
From: owner-statalist@hsphsun2.harvard.edu
[mailto:owner-statalist@hsphsun2.harvard.edu] On Behalf Of Nick Cox
Sent: Wednesday, February 14, 2007 5:15 PM
To: statalist@hsphsun2.harvard.edu
Subject: st: RE: DLL for Stata to facilitate integration of Stata
programs with MS Excel Visual Basic

I'd be very surprised if any such thing existed. StataCorp 
espouses a cross-platform style and is not in the habit 
of privileging stuff for particular operating systems or 
particular proprietary products that it does not market itself. 

I'd also guess wildly that user-programmers, however skilled, 
wouldn't know enough about Stata's internals to be able to
write this. And they mostly would have no interest in 
writing anything like this even if they could. Well, I 
wouldn't. 

Nick 
n.j.cox@durham.ac.uk 

Rodriguez, Dan (FIRMMKTRSK)
 
> I would like to access a DLL for Stata that allows me to launch Stata
> programs from within Microsoft Excel Via Visual Basic Code. Currently,
> we are able to launch Matlab programs from within Excel, but not Stata
> programs. Can you please let me know if there exists such a library?

*
*   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/ 
  
_____________________________________________________________ 
  
This e-mail and any attachments may be confidential or legally privileged.  If you received this message in error or are not the intended recipient, you should destroy the e-mail message and any attachments or copies, and you are prohibited from retaining, distributing, disclosing or using any information contained herein.  Please inform us of the erroneous delivery by return e-mail.  
  
Thank you for your cooperation. 
  
_____________________________________________________________ 
 

*
*   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/



© Copyright 1996–2014 StataCorp LP   |   Terms of use   |   Privacy   |   Contact us   |   What's new   |   Site index