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: [email protected]
[mailto:[email protected]] On Behalf Of Nick Cox
Sent: Wednesday, February 14, 2007 5:15 PM
To: [email protected]
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
[email protected]
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/
