LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (March 2004, week 4)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:   Mon, 22 Mar 2004 11:57:48 -0500
Reply-To:   Kevin Roland Viel <kviel@EMORY.EDU>
Sender:   "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:   Kevin Roland Viel <kviel@EMORY.EDU>
Subject:   Activating an Excel workbook
Content-Type:   TEXT/PLAIN; charset=US-ASCII

I copy one sheet to another workbook using DDE and the function WORKBOOK.COPY. However, I am unable to copy another apparently because the second workbook is activated. I see a work around by copy only one sheet at a time. Is there a way to return control to the first? The function ACTIVATE did not seem to work:

put '=ACTIVATE("book1")';

Thanks,

Kevin

Kevin Viel Department of Epidemiology Rollins School of Public Health Emory University Atlanta, GA 30322


Back to: Top of message | Previous page | Main SAS-L page