Re: SDI demo by Keisuke
For your information, I wrote the SDI demo on Mac, including the Excel/4D integration part. It worked on my work computer which had Microsoft Excel from 2015 (15.16). But when I tested on a new Mac with Excel 2016, the same code did not work. it seems like VBA Tools needs some work on for Excel 2016. https://github.com/VBA-tools/VBA-Web/issues/248 ** 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 **
Re: SDI demo by Keisuke
the last time tested, VBA Tools (which is an cross platform HTTP client for VBA that does the mapping between JSON and VBA) works on Microsoft Excel for Mac 15.16 but not the version after that (I keep a copy of the old version in addition to the current one). I don't know if it was fixed in newer version of Excel. VBA Tools on mac does some pretty radical things on Mac, such as loading dylib and calling curl from VBA, and it seems the VBA editor for Mac is undergoing a lot of changes. On top of that, mobile versions of Excel don't support VBA, so is seems VBA might not be the best way to add macros to your spreadsheet if you don't have full control over the platform or version your clients' Excel. If you attended the Summit then you should soon receive an update download link for the SDI demo. ** 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 **
SDI demo by Keisuke
In the keynote presentation by Keisuke, he showed briefly opening an excel document and fetching data from the 4D database. Now, I know this can be done using ODBC, but it is not easy to get that working on a Mac. Furthermore, Excel 2016 doesn’t seem to be able to connect to 4D. (It used to be ok using the old MS query) So I am hoping this feature that was demoed also works on Mac. Although I could find the SDI database on the usb key of the Paris Summit, I couldn’t find this particular feature. Mind you, the SDI database is NOT on the US Summit usb key. Keisuke, I googled the VBA tools you mentioned, but didn’t get the answers I needed. Could you elaborate a little more on that, and how you implemented that little demo? Regards, Rudy Mortier Two Way Communications bvba ** 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 **