Excel VBA: How to Solve: DDE stops when remote application disconnect?
If Application.OnTime isn't firing, it means that the function called by Application.OnTime is hung or crashed. My suggestion is that you write your own Sub and cause it to be called from Application.OnTime --- then you can use On Error to check for any crash, also you can log somewhere...
OpenOffice DDEExecute Failing
OpenOffice uses 'OpenOffice Basic', previously known as StarBasic. So it does not understand the command 'File.CLOSE()'. The corresponding OpenOffice Basic command is 'thisComponent.close(true)'. https://wiki.openoffice.org/wiki/Documentation/BASIC_Guide...
DDE Client in Service talking to a server in user session
c++,session,winapi,service,dde
Starting with Vista, "interactive" services do not work anymore, because of Session 0 Isolation. DDE is a User32-based technology (it uses window messages internally), and as such cannot be used across session boundaries. To do what you are attempting, you will have to create a separate non-service app that runs...
SAS: use oberservation
The usual way to use values from a dataset as a part of command/statement is CALL EXECUTE routine: DATA _null_; SET test; call execute("DATA _NULL_;"); call execute(cats("FILENAME ExcelTmp DDE ""EXCEL|[&myInputTemplate.]&mySheet.!",cell,""";")); call execute("FILE ExcelTmp NOTAB LRECL=7000;"); call execute("PUT '"||res||"';"); call execute("RUN;"); run; This code generates DATA-steps that stacked up in a...
Connecting to DDE datasource
Ended up using VB 2008 to write an application that uses the NDde library. Working correctly now.
Implementing delay in data export from Excel to csv file
excel,excel-vba,csv,file-io,dde
Refer to the following example of using DoEvents demonstrating how to add responsiveness to the program during execution of a lengthy loop: Open "com1" For Input As #1 Input #1, x Do Until x = Chr(13) DoEvents '... '... Input #1, x Loop Another example: X = Timer() Do While...