ActiveX controls are removed from file

For some Excel files (*.xlsx and *.xlsm) ActiveX controls are removed after the file has been processed by some instructions.

Why does this happen?

The reason for this is that current versions of Microsoft Excel save ActiveX controls in a non-standardised language called VML, and this language is not supported by the technologies that manipulate the underlying Excel data.

Note that “Form controls” are not impacted by this issue. When adding buttons, list boxes and links to a spreadsheet, you can do this with either ActiveX controls or Excel Form controls. They look and behave similarly, however Form controls will not be impacted by this issue. We advise clients that are manipulating files with controls in them to use Form as opposed to ActiveX controls.

How to fix this

Workaround is in two steps:

  1. Convert file into *.xls format.
  2. Convert ActiveX control to the form control. For example – ActiveX Command button to normal form button, and reconfigure the associated macros.
Leave a Reply

Latest Tweets

Free eBook: 10 Tips for sourcing good data yucalc.com/2017/02/17/fre…

reply · retweet · favorite

Newsletter

By signing up, you agree to our Terms of Service and Privacy Policy.

Address

Suite 1506, Westfield Tower 2, 101 Grafton St Bondi Junction NSW 2022 Australia

View Larger Map

Contact Us

AUS: +61-2-9386-0202
UK: +44-20-8123-1251
Send us an email

ContactUs.com
WordPress Image Lightbox