I have a macro I need to convert to VBA.
It is in a XLM file that ref's a DLL... it sends a value in a spreadsheet to a device via DDE.
It uses the A and B column - B2 has a number in it.. A has these commands in it
Text:
PokeMacro - CTRL A
=INITIATE("DASOMFINSEnet","TOPIC1")
=POKE(A2,"D100",B2)
=RETURN
That's it. The macro works, it sends data to a DDE server running on the machine. I just can't figure out how to turn it into VBA code. I know how to code VBA, but have no idea how to converts these calls to VBA.
Thanks for the help.
Buc
It is in a XLM file that ref's a DLL... it sends a value in a spreadsheet to a device via DDE.
It uses the A and B column - B2 has a number in it.. A has these commands in it
Text:
PokeMacro - CTRL A
=INITIATE("DASOMFINSEnet","TOPIC1")
=POKE(A2,"D100",B2)
=RETURN
That's it. The macro works, it sends data to a DDE server running on the machine. I just can't figure out how to turn it into VBA code. I know how to code VBA, but have no idea how to converts these calls to VBA.
Thanks for the help.
Buc
