Excel Error: Run-time error '91'
After adding the Bulk data manager and the DataDirect add-ins to Excel, the following error started to prompt every time i start excel,
"Run-time error '91', object variable with block variable not set"
How can i solve this issue?
Voted best answer
Run LBEInstallAddins.exe from 'C:\Program Files (x86)\ABB Industrial IT\Engineer IT\Engineering Studio\Bulk Data Manager\bin', which will install the proper BDM addins. This should solve the problem.
If not, check that you have installed 32-bit version of Excel.
Also, MS Office Professional is supported, not MS Office Standard.
Last option would be to un-install Data Direct and Excel, then reboot the node, then reinstall Excel first, reboot and install Data Direct.