I use win32ole to access excel-workbooks.
When ruby opens a workbook with links to other workbooks an alert box
pops up and you have to confirm whether you want to keep those links
This is very annoying in my application.
is there a way to surpress the box and choose “no” by default?
to be filled with all Excelconstants
once excel is running
xl = WIN32OLE.new(‘Excel.Application’)
All Excel constans are now available.
NB they all start with an uppercase letter.
use XlUpdateLinksAlways for the opposite effect.