Excel DDE format for System Manager Software (SMS) quantities

FA212248

16/05/2020

Product Line   
SMS 3.3.x
SMS 4.x

Resolution
Excel uses the following format to read System Manager Software (SMS) data via DDE:
=SystemName|DeviceName!QuantityAbbreviation

The quantity abbreviation can be found by looking at the standard quantity in the System Manager Setup Utility.

1. Go to Setup and click Custom Quantities.
2. Uncheck "Show Custom Quantities Only".
3. Highlight the quantity in question.
4. The abbreviation is listed below the Quantities box.