Browse FAQs

Excel DDE format for System Manager Software (SMS) quantities

Published date: 15 May 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.


Was this helpful?

What can we do to improve the information ?

Can't find what you are looking for?

Reach out to our customer care team to receive information on technical support, assistance for complaints and more.