Support Forums
Problem using VTScada as DDE Server with Excel

I'm using VTScada to run an application linking this software to MATLAB through Excel.
When writing from Matlab to Excel,and Excel to MATLAB, everything works fine.

When using VTScada as DDE Server,and writing data to my Excel, by using the following formula:

=VTS|'NewApplication'!'L1\Value'

I get a message telling me that I have to open VTScada,even if the problem is already running. I check on 'yes',then getting an error message telling me : "impossible opening VTS.exe. One of its components is damaged or missing"

I tried running both problems as an admistrator,but it still doesn't work. What should I do?

I'm using VTScada to run an application linking this software to MATLAB through Excel. When writing from Matlab to Excel,and Excel to MATLAB, everything works fine. When using VTScada as DDE Server,and writing data to my Excel, by using the following formula: =VTS|'NewApplication'!'L1\Value' I get a message telling me that I have to open VTScada,even if the problem is already running. I check on 'yes',then getting an error message telling me : "impossible opening VTS.exe. One of its components is damaged or missing" I tried running both problems as an admistrator,but it still doesn't work. What should I do?

Starting with VTScada 12.0, DDE is disabled by default for security purposes.

To enable it the VTScada process must be started using either the /D or /d option. See the help topic Use VTScada as a DDE Server for more info.

Also see this info from MS about DDE disabling in Office products.

Starting with VTScada 12.0, DDE is disabled by default for security purposes. To enable it the VTScada process must be started using either the `/D` or `/d` option. See the help topic [Use VTScada as a DDE Server](https://www.vtscada.com/help/Content/D_DataSharing/D_DDEServer.htm) for more info. Also see [this](https://docs.microsoft.com/en-us/security-updates/securityadvisories/2017/4053440) info from MS about DDE disabling in Office products.

Software Developer with Trihedral

39
1
2
live preview
enter atleast 10 characters
WARNING: You mentioned %MENTIONS%, but they cannot see this message and will not be notified
Saving...
Saved
With selected deselect posts show selected posts
All posts under this topic will be deleted ?
Pending draft ... Click to resume editing
Discard draft