PlanetSquires Forums

Support Forums => General Board => Topic started by: Eigil Dingsor on May 14, 2018, 03:55:34 PM

Title: FB skeleton code for making generic XLL files for use with Excel 32 Bit
Post by: Eigil Dingsor on May 14, 2018, 03:55:34 PM
Hi,
I've programmed  xll files for Excel in PowerBasic for more than 20 years. At some stage I'll have to switch to  Excel 64 bit and then my Excel 32 bit add-ins will become obsolete. In order to stay ahead I've started to convert my PB code to FB since PB is only 32bit. At first into FB 32 bit code.
The enclosed zip file contains the neccesary files that enables you to make your own Excel add-ins.

Eigil
Title: Re: FB skeleton code for making generic XLL files for use with Excel 32 Bit
Post by: Andrew Lindsay on May 14, 2018, 08:24:39 PM
Eigil,

Let me say thank you for sharing this with the community.  I have used your framework in PowerBasic many, many times.  It has saved me literally days in processing time over the years, from having spreadsheets that take an hour to process to reduce that down to a couple of minutes or even quicker has been an absolute godsend.

It has literally made an unworkable solution workable, on so many occasions. 

Thank you.

Andrew
Title: Re: FB skeleton code for making generic XLL files for use with Excel 32 Bit
Post by: Eigil Dingsor on May 15, 2018, 02:51:30 AM
Hi Andrew,
Thanks for kind words. I believe in sharing and not re-inventing the wheel over and over again. I'm very new to FB, but like the mix of Basic and C syntax and also the ability to compile c code as static libraries  into final FB code. Saves a lot of re-coding.
Eigil
Title: Updated : Re: FB skeleton code for making XLL files for use with Excel 32 Bit
Post by: Eigil Dingsor on December 11, 2019, 03:41:07 PM
Hi,
I finally got the time to convert the Excel 2007+ entry code functions from C/C++ to Freebasic. You no longer have to include the GCC compiled C static library in your code. Just replace with XLCALL32_CPP.BAS file. Now it will  be even easier to migrate from a 32bit to 64bit world.

Have also changed  code in framewrkc.bi module to get the TempInt/TempInt12 to work properly when calling Excel4/Excel12 functions.
See line: DIM SHARED  vMemBlock(MEMORYSIZE)as BYTE ' Memory for temporary XLOPERs
Enjoy and post questions if you have any!

Eigil