Intouch action script

Hi there

I have an action script that sends some number to a cell in excel (r3,c4).

I use the WWPoke command to do this.

Can I write a code so next time the script is activated it input data to (r4,c4).?

I want the data to sends to the next empty cell in that specific row.

If I have to use macros in excel please guide me through the intouch script and the excel macro code.

Best regard

Suppose you created a Memory Message tag named "DDEItemNameA".

Then suppose you created a Memory Integer tag named "DDERowNumber".

Suppose that your pushbutton script did this:

IF DDERowNumber < 10 THEN
DDERowNumber = DDERowNumber+1;
ELSE DDERowNumber = 1;
ENDIF;

DDEItemNameA = "r" + DDERowNumber;


That might get you started in the right direction.

Thanks! I will check it out

I got this poke command:

MTag = Text(data,"0");

WWPoke("EXCEL","[Simac.xlsx]Ark1", "r3c3", MTag);

But when I put in your script and error pops up:

"Cannot mix another type with string"

Can you tell what's wrong?

MLR5000 said:

But when I put in your script and error pops up:

"Cannot mix another type with string"

Can you tell what's wrong?

Click to expand...

I think so. You need to extract the integer value in the "DDERowNumber" tag into a Message tag in order to append the value to the letter "r" in the "DDEItemNameA" tag.

Use the StringFromIntg function to do this. You need to create another Memory Message tag. We'll call it "RowNumber".


So then... On Left Key Down...


IF DDERowNumber < 10 THEN
DDERowNumber = DDERowNumber + 1;
ELSE DDERowNumber = 1;
ENDIF;

RowNumber = StringFromIntg (DDERowNumber,10);

DDEItemNameA = "r" + RowNumber + "c3";

Then use the tag "DDEItemNameA" as the item name in your WWPoke function.


Maybe that will work better? We musn't mix data types!

Thanks for your help, I really appreciate that

I will try the script later today and post some comments.

I works great! Thank you

If I run in to more problems I now know which expert to contact

Best regards Martin