Seeking info on how to create a dll function

Hello

I'm planning to upgrade MC to the 64 version. To do so, I will need to have a function with a dll to send a string of data to Excel cell directly,

There is a collection that already exist, but it is paid with an annually subscription and I use only one function out of the entire one

So my goal is to write a dll collection to send via com object data to Excel worksheet cell from MC.

Question are:
- Where do I start,
- What do I need
- Is there a free compiler that could be use


Look like an easy job, but I just don't know where to start

Martin

P.S.
Here is the actual PowerLanguage code for the command that send a string to my Excel sheet And the code of the function XLO.TextA1 Any help appreciated

Hello

I'm planning to upgrade MC to the 64 version. To do so, I will need to have a function with a dll to send a string of data to Excel cell directly,

There is a collection that already exist, but it is paid with an annually subscription and I use only one function out of the entire one

So my goal is to write a dll collection to send via com object data to Excel worksheet cell from MC.

Question are:
- Where do I start,
- What do I need
- Is there a free compiler that could be use


Look like an easy job, but I just don't know where to start

Martin

P.S.
Here is the actual PowerLanguage code for the command that send a string to my Excel sheet

Code: Select all

Condition0 = XLO.TextA1(sBook,sSheet,Cell_,InitString);

And the code of the function XLO.TextA1

Code: Select all

Once($QCL.Signature);
{
5/5/2010
}
external method: "!QCL-ELXL-100224wm.dll", bool, "SetTextByA1", LPSTR, LPSTR, LPSTR,
LPSTR;

Inputs:
sBook(stringsimple),
sSheet(stringsimple),
sCellA1(stringsimple),
sValue(stringsimple);

{ Avoid frequent calls. }
XLO.TextA1 = SetTextByA1(
sBook,
sSheet,
sCellA1,
sValue

Any help appreciated

Check out the BASIC compilers. eg. Purebasic, Freebasic, etc., Many of them have libraries already written for TS and Excel.