mulderm
Member
Hello,
In Excel I have the follow VBA-code:
Const bit8 as integer = 256
dim channelnum as long
dim woord1 as integer, hulpwoord1 as integer
channelnum=DDEInitiate("RSLINX", "Topic")
woord1=DDERequest(channelnum, "N7:0")
hulpwoord1=woord1 / bit8 'giving type mismatch
DDETerminate channelnum
Problem: When I get the value of N7:0 (13112) I get a type
mismatch error nr:13 in my code by the row hulpwoord1.
Who knows the problem?
I want to convert the Integer N7:0 to 2 ascii karakters.
For N7:0=13112 LSD=8 and MSD=3
mulderm
In Excel I have the follow VBA-code:
Const bit8 as integer = 256
dim channelnum as long
dim woord1 as integer, hulpwoord1 as integer
channelnum=DDEInitiate("RSLINX", "Topic")
woord1=DDERequest(channelnum, "N7:0")
hulpwoord1=woord1 / bit8 'giving type mismatch
DDETerminate channelnum
Problem: When I get the value of N7:0 (13112) I get a type
mismatch error nr:13 in my code by the row hulpwoord1.
Who knows the problem?
I want to convert the Integer N7:0 to 2 ascii karakters.
For N7:0=13112 LSD=8 and MSD=3
mulderm