Author Topic: Using Oxygen in Excel VBA  (Read 107 times)

0 Members and 1 Guest are viewing this topic.

edcronos

  • Newbie
  • *
  • Posts: 18
Using Oxygen in Excel VBA
« on: December 05, 2017, 10:13:49 PM »
Hello
I want to start my learning in the oxygen
but I only use programming for some personal works on excel vba
then I would like to know if it has how to use directly inside the vbedit transferring byref arrays for work
If the answer is yes, is there an example of a condition?

edcronos

  • Newbie
  • *
  • Posts: 18
Re: Using Oxygen in Excel VBA
« Reply #1 on: December 07, 2017, 08:56:20 AM »
I researched here in the forum, and on the thinbasic over Oxygen dll
but I think I'll have to create the dll directly from my macros and functions in C or Oxygen,
safearray in C is already well described, but in Oxygen I'm in doubt.
also have those of binary 128bit operators that I intend to use
I have to think about what strategy I'm going to bet
remembering that I am not a programmer but a user

Charles Pegge

  • Author
  • *****
  • Posts: 3290
    • Oxygen Basic
Re: Using Oxygen in Excel VBA
« Reply #2 on: December 07, 2017, 09:50:11 AM »
Do you intend to read/write  Excel spreadsheet file data directly?

edcronos

  • Newbie
  • *
  • Posts: 18
Re: Using Oxygen in Excel VBA
« Reply #3 on: December 07, 2017, 10:10:38 AM »
Hello
no,
vba takes data from the worksheet, passes it to the dll "usually an array", and pastes the result into the "often in array"
Most of the things I do in the vba account, but I've tried to put together complex things in the order of billions of tests that takes more than 8 minutes
binary 128 bit operators would also greatly streamline my projects

Charles Pegge

  • Author
  • *****
  • Posts: 3290
    • Oxygen Basic
Re: Using Oxygen in Excel VBA
« Reply #4 on: December 08, 2017, 04:46:24 AM »
I don't see any difficulty working with safearrays. I can assist with using the oleauto API.

What type of 128bit operations will you be using? Is it 128 bit signed integer?

edcronos

  • Newbie
  • *
  • Posts: 18
Re: Using Oxygen in Excel VBA
« Reply #5 on: December 08, 2017, 07:22:06 AM »
I'm not very dependent on safearray, but it makes it easier to work with data straight from the worksheet, which for more lay folks can help, much more if you allow variant type to work with mixed tables
I particularly use more with integers and dates

yes, they are sequences transformed into integers for comparison, filtering, parity ...
loops between values is very scatter

Charles Pegge

  • Author
  • *****
  • Posts: 3290
    • Oxygen Basic
Re: Using Oxygen in Excel VBA
« Reply #6 on: December 09, 2017, 06:57:06 PM »

Can your version of Office use 64 bit DLLs? 128bit integer calculations are significantly faster and simpler when the cpu is running in 64bit mode.

edcronos

  • Newbie
  • *
  • Posts: 18
Re: Using Oxygen in Excel VBA
« Reply #7 on: December 10, 2017, 07:47:54 AM »
I had forgotten that fact.
if it is necessary I change my version of excel, mine is 2010 32bit
I think the license is valid for both versions

for me it is strange this lack of sharing, I went to see and there really is a difference of sizes of variables of the same type
where to change the variable if the size changes