Can't find the information you are looking for here? Then leave a message over on our WinBatch Tech Support Forum.
Keywords: DDE
I haven't used DDE with Word, but here's some of my DDE code for selecting and updating Access. But don't try to SQL INSERT anything unless you want more frustration. :)
; to select a record SQLstmt='SELECT MAX(Root) FROM Root_URL;' channel = DDEInitiate("MSAccess","%MDB%;SQL") ; open DDE channel if channel > 0 if DDEPoke(channel,"SQLtext",SQLstmt) maxroot = DDERequest(channel,"DATA") else Message(nm,"DDEPoke() for maximum root failed") Exit endif DDETerminate(channel) ; close DDE channel else Message(nm,"DDEInitiate() failed") Exit endif ; to update a record channel=DDEInitiate("MSAccess","%MDB%;SQL") if channel > 0 SQLstmt='UPDATE Root_URL SET LastScan="%today%"' SQLstmt='%SQLstmt% WHERE Root="%root%";' if DDEExecute(channel,'[RunSQL %SQLstmt%]')==@FALSE FileWrite(ft,`UPDATE failed:%@CRLF%%SQLstmt%`) Message(nm,"UPDATE failed") Exit endif DDETerminate(channel) endif ; to insert a record -- many problems... ; Ask God to do it :)
Article ID: W12807
Filename: DDE Code to Update Access.txt
File Created: 1999:04:15:16:49:46
Last Updated: 1999:04:15:16:49:46