Include Add-ins on Opening an Excel

[Anonymous]

I'm using MS Excel VBO, by creating an instance, showing and opening my workbook. Whenever i open my workbook, my add-ins on excel are not included. Any idea how to include my add-ins on opening the excel while using the MS Excel VBO?

[Anonymous]

Hi Kenneth, You can create a new open action on the Excel VBO and use the below code. Hopefully this will help. Dim wb as Object = GetInstance(handle) wb.DisplayAlerts = False wb.Workbooks.Open(filename) wb.DisplayAlerts = True Make sure you have this as a backup, as when you upgrade your BP, these will be replaced with accompanying VBOs Regards, Hari