Members of the Forum - if someone else has Office 2007 installed, could you check that my three OLE Excel changes work (and are necessary)?
The first change is to save the JMACROS file (probably at ~system\examples\ole\excel\jmacros.xls) in Excel 2007 as a macro-enabled spreadsheet, i.e. ".xlsm" file. The two changes to ~system\examples\ole\excel\xlutil.ijs are: change the JMACROS variable to point to the new ".xlsm" file, and change the line in "xlopen" from wd 'cc xl oleautomation:excel.application' to wd 'cc xl oleautomation:Excel.application' NB. Change "excel" to " Excel". Making only this latter change appears not to break "xlopen" for an older version of MS Office (2003). I don't know how to generalize the change of the JMACROS file from ".xls" to ".xlsm" depending on the version of Office because I don't know a good way to determine which version is active. Thanks, Devon On 3/18/08, Devon McCormick <[EMAIL PROTECTED]> wrote: > > 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 > -- Devon McCormick, CFA ^me^ at acm. org is my preferred e-mail ---------------------------------------------------------------------- For information about J forums see http://www.jsoftware.com/forums.htm
