Perfect. Thanks. Henry Rich
David Mitchell wrote: > Henry Rich wrote: >> I need to read/write from spreadsheets. I think I need to use the >> OLE interface to Excel so I can access spreadsheets while they are >> open for editing (I hope this is possible). >> >> I tried xldemo.ijs, but that crashed. Then I tried the tables\excel >> addon but that popped up a Microsoft Forms window saying I was missing >> something. >> >> Can anybody help me get started with this, by showing me something that >> will work for a simple case? >> >> xlutil.ijs says something about creating jmacros.xls from jmacros.txt. >> jmacros.txt seems to be VBasic code - can anyone tell me how to produce >> jmacros.xls from that (providing that I need it to access the spreadsheet)? >> >> Henry Rich >> ---------------------------------------------------------------------- >> For information about J forums see http://www.jsoftware.com/forums.htm >> > > I just followed these steps and xldemo0'' worked fine on Windows XP: > > 1. Open Excel > 2. Select Tools->Macro-Visual Basic Editor > 3. Select File->Import File > 4. Set Files of Type to all > 5. Open j602/system/examples/ole/excel/jmacros.txt > 6. Close Visual Basic Editor > 7. Select File->Save As... > 8. Save as j602/system/examples/ole/excel/jmacros.xls > 9. In J, load xldemo.ijs > 10. run xldemo0'' > > -- > Cheers, > David Mitchell > ---------------------------------------------------------------------- > For information about J forums see http://www.jsoftware.com/forums.htm > ---------------------------------------------------------------------- For information about J forums see http://www.jsoftware.com/forums.htm
