Technical FAQs

Ask a Question

Excel DDE format for System Manager Software (SMS) quantities

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.

Was this helpful?
What can we do to improve the information ?