Allan I think I have the code you refer to. if it is the component that uses vbs scripts(such as application_arrange_windows.vbs)..this might have been something other than Miyakos’ code.. contact me off list and i can put a copy of this on a drop box for you.
C_TEXT($1) C_TEXT($2) C_TEXT($3) C_TEXT($4) SCPT_XL_SetParameter ("XCEL_WORKBOOK_NAME";$1) SCPT_XL_SetParameter ("XCEL_SHEET_NAME";$2) SCPT_XL_SetParameter ("XCEL_RANGE";$3) SCPT_XL_SetParameter ("XCEL_VALUE";$4) SCPT_XL ("range_set_value”) Nigel > On 7 May 2018, at 09:44, Allan Udy via 4D_Tech <4d_tech@lists.4d.com> wrote: > application_arrange_windows > Hi All, > > I'm up the proverbial creek without a paddle... > > Years ago (v11) we started using the 'Excel Library' component put together > (I think) by Keisuke. For the life of me I can no longer find a source > version of this (if there ever was one), and it appears that any online link > to the component no longer exists. > > At one point we did get the component upgraded to work in a v14 database. > Seems (under MacOS at least) that it's still working under v16, but it's > plainly only 32-bit. Due to a couple of other reasons we now need to look at > taking this single-user app to 64-bit, and of course it won't work. :-( > > I have found Keisuke's 4d-plugin-xls > (https://github.com/miyako/4d-plugin-xls), but this does not appear to > contain options to find and set cell ranges as the earlier component did, nor > is there any sensible documentation, so it's not really useable. > > I'm aware of Pluggers XL Plugin, but at 600 Euro it's going to be hard sell > for our client when only basic use is made of Excel (Open a spreadsheet, > find a couple of named cells, put data in those cells, save the spreadsheet). > > Are there any other options out their to interface a 4D app with an Excel > spreadsheet? > > Cheers, > Allan Udy > > Golden Micro Solutions Ltd, Blenheim, New Zealand > http://www.golden.co.nz<http://www.golden.co.nz> > > ********************************************************************** > 4D Internet Users Group (4D iNUG) > FAQ: http://lists.4d.com/faqnug.html > Archive: http://lists.4d.com/archives.html > Options: https://lists.4d.com/mailman/options/4d_tech > Unsub: mailto:4d_tech-unsubscr...@lists.4d.com > ********************************************************************** ********************************************************************** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **********************************************************************