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
