Bill - thanks for the hint! While browsing through the registry for all occurrences of "excel", I found a ddeexec\application reference to "Excel".
This led me to edit "xlopen" in "xlutils.ijs" from wd 'cc xl oleautomation:excel.application' to wd 'cc xl oleautomation:Excel.application' NB. Change "excel" to "Excel". Also, I converted the jmacros file to "jmacros.xlsm" (Excel 2007 "macro-enabled" spreadsheet) and assigned "JMACROS_excel_" (also in xlutils.ijs) to point to this file. This seems to have done the trick, though it seems odd that the OLE call would be case-sensitive when almost nothing else in the Windows world is. Eric - thanks for your help as well. Can this be incorporated in the "ole/excel" library at some point? I'll take a look at the backward compatibility of "Excel" versus "excel" and let you know what I find. Thanks again! Devon On 3/17/08, bill lam <[EMAIL PROTECTED]> wrote: > > I don't have office 2007 to test. You may try using regedit to look at > HKCR for > the excel.application. > > > Devon McCormick wrote: > > Yes - all the spreadsheets I have are in 2003 format but I suspect maybe > the > > OLE automation object has a different name or something. > > > > On 3/17/08, Ralph G Selfridge <[EMAIL PROTECTED]> wrote: > >> I have Office 2007, same sort of troubles. But have you noticed that > you > >> can 'save as' for 2003. > >> > >> > >> > >> > >> On Mon, 17 Mar 2008, Devon McCormick wrote: > >> > >>> I'm starting to suspect this may have to do with having only MS Office > >> 2007 > >>> installed on my machine. > >>> Are there known OLE issues with this version of Excel? > >>> > >>> When I try as you suggested, I get the following: > >>> wd 'qer' > >>> bad class : 0 > >>> 13!:1'' > >>> |domain error > >>> *wd[0] > >>> | wd'cc xl oleautomation:excel.application' > >>> |xlopen_excel_[6] > >>> | xlopen_excel_'' > >>> > >>> > >>> > >>> On 3/17/08, Eric Iverson <[EMAIL PROTECTED]> wrote: > >>>> wd'qer' will give you more info about the problem. > >>>> > >>>> wd should work from jee, but there a a few more layers involved. You > >> might > >>>> want to try the wd stuff from a normal jwdw session to track down the > >>>> problem. > >>>> > >>>> > >>>> ----- Original Message ----- > >>>> From: "Devon McCormick" <[EMAIL PROTECTED]> > >>>> To: "J-programming forum" <[email protected]> > >>>> Sent: Sunday, March 16, 2008 6:42 PM > >>>> Subject: [Jprogramming] "wd" fails under "jee" > >>>> > >>>> > >>>>> Members of the Forum - > >>>>> > >>>>> I was attempting to read data from a spreadsheet using the OLE > >>>> automation > >>>>> facility running the "jee.exe" under emacs, when I got the following > >>>>> error: > >>>>> |domain error: wd > >>>>> | wd'cc xl oleautomation:excel.application' > >>>>> > >>>>> I thought wd commands are supposed to work under jee - is this > >>>> incorrect? > >>>>> Could there be a problem specifically with OLE? I'm running J > >> 6.02under > >>>>> Windows XP. > >>>>> > >>>>> Thanks, > >>>>> > >>>>> Devon > >>>>> > >>>>> -- > >>>>> Devon McCormick, CFA > >>>>> ^me^ at acm. > >>>>> org is my > >>>>> preferred e-mail > >>>>> > ---------------------------------------------------------------------- > >>>>> For information about J forums see > http://www.jsoftware.com/forums.htm > >>>> > ---------------------------------------------------------------------- > >>>> For information about J forums see > http://www.jsoftware.com/forums.htm > >>>> > >>> > >>> > >>> -- > >>> Devon McCormick, CFA > >>> ^me^ at acm. > >>> org is my > >>> preferred e-mail > >>> ---------------------------------------------------------------------- > >>> For information about J forums see http://www.jsoftware.com/forums.htm > >>> > >> ---------------------------------------------------------------------- > >> For information about J forums see http://www.jsoftware.com/forums.htm > >> > > > > > > > > ---------------------------------------------------------------------- > For information about J forums see http://www.jsoftware.com/forums.htm > -- Devon McCormick, CFA ^me^ at acm. org is my preferred e-mail ---------------------------------------------------------------------- For information about J forums see http://www.jsoftware.com/forums.htm
