Barcode macros do not run, files do not open or #NAME error is displayed
Solution(s):
When using
Barcode Macros and VBA for Microsoft Office or
ActiveX Barcode Controls in a
barcode field with Office XP, 2000 & 2003,
one of the following may occur:
- A macro in Excel may return #NAME in the field that is supposed
to represent a barcode.
- The file may open without any warnings and the barcode may not
be displayed.
- Security settings may restrict access to the file, so that it
will not open.
Usually this is due to the Microsoft Office security level being
set at HIGH, thus preventing any macros from running or ActiveX Controls
from being used. This can be resolved by performing the following:
- In the application, choose Tools – Macro – Security and
set the security level to medium.
- Save and close the document.
- Reopen the document and choose “enable macros” when prompted.
To avoid these errors in a solution that is distributed, IDAutomation
suggests signing the files and macros in the solution.
Related Documents:
|
