LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous (more recent) messageNext (less recent) messagePrevious (more recent) in topicNext (less recent) in topicPrevious (more recent) by same authorNext (less recent) by same authorPrevious page (February 2011, week 2)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:   Fri, 11 Feb 2011 16:53:50 -0500
Reply-To:   Richard DeVenezia <rdevenezia@GMAIL.COM>
Sender:   "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:   Richard DeVenezia <rdevenezia@GMAIL.COM>
Subject:   Re: Running SAS through Excel VBA Macros
Comments:   To: Tanmoy Mukherjee <tkmcornell@yahoo.com>
In-Reply-To:   <421585.14761.qm@web30208.mail.mud.yahoo.com>
Content-Type:   text/plain; charset=ISO-8859-1

Tanmoy:

Search up: SAS Windows Automation Object and you will find a paper "Using SAS as an Automation Server in Windows Application Development" by Zhuan (John) Xu -- http://www2.sas.com/proceedings/sugi23/Appdevel/p3.pdf

Enjoy!

Richard A. DeVenezia http://www.devenezia.com

On Thu, Feb 10, 2011 at 6:12 PM, Tanmoy Mukherjee <tkmcornell@yahoo.com> wrote: > I will appreciate if someone can guide me with regards to running SAS V9.2 through Excel 2010 VBA Macros. I have a excel macro that calls an outside database, creates a dataset which then needs to be run on SAS V9.2 and then the results exported to Excel again. Since all we are doing outside of Excel is running SAS I was wondering if a VBA code can be written to call the SAS program and execute the query. > > I will appreciate if someone can guide towards the same. > > Thanks and Regards, > Tanmoy

Back to: Top of message | Previous page | Main SAS-L page
listserv.uga.edu
Enterprise Information Technology Services
The University of Georgia
listhelp@uga.edu