Bill, Thanks, that is exactly the way I would like to do it. I probably should have checked the OLE Excel Client tutorial first, but I found this comment in it:
Reading and Writing Ranges In practice, you will typically want to read and write a range of cells. It would be tedious to do so one cell at a time; unfortunately, the form in which Excel reads and writes range data is not available to J. The solution is to use the utilities xlreadr (read range) and xlwriter (write range) that call appropriate macros from jmacros.xls. This obviously explains why it was originally implemented using the clipboard and paste. But, the tutorial is for Excel 97 and J401, so my question is: Do you (or anyone) know if J now has access to "the form in which Excel reads and writes range data"? Ed Cox Principal Data Analyst MedMined(tm) _________________________________________________ This message is for the designated recipient only and may contain privileged, proprietary or otherwise private information. If you have received it in error, please notify the sender immediately and delete the original. Any other use of the email by you is prohibited. Dansk - Deutsch - Espanol - Francais - Italiano - Japanese - Nederlands - Norsk - Portuguese Svenska: www.carefusion.com/legal/email ---------------------------------------------------------------------- For information about J forums see http://www.jsoftware.com/forums.htm
