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