PlanetSquires Forums

Please login or register.

Login with username, password and session length
Advanced search  

Author Topic: FB skeleton code for making generic XLL files for use with Excel 32 Bit  (Read 1836 times)

Eigil Dingsor

  • Little Newbie
  • *
  • Posts: 16

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
Logged

Andrew Lindsay

  • Junior Member
  • **
  • Posts: 76

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
Logged

Eigil Dingsor

  • Little Newbie
  • *
  • Posts: 16

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
Logged

Eigil Dingsor

  • Little Newbie
  • *
  • Posts: 16

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

Logged