Vb.Net - Excel 2013 Invalid Index
Posted on 2014-09-12
Good Day Experts!
I am in a bit of a quandry here. I have a VB.Net application with a TabControl that has multiple "Export to Excel" buttons on the Tabs. It has worked fine for 2years on XP machines and recently Windows7 machines.
However, we just upgraded a User to Office 2013 and now I am having trouble when trying to "Export to Excel". Message received --> Invalid Index. (Exception from HRESULT:0x8002000B (DISP_E_BADINDEX)). When I go to my machine which is Windows7 and Office 2010 I have no troubles.
Perhaps I need to create the objects a bit different for 2013 but I am not sure?
Do you have any ideas?