Have a situation where, from Access, I need to open and manipulate an Excel workbook. Has worked fine, customer just upgraded to Office 16, now not working.
My VBA code in Access (1) opens an instance of Excel and makes it visible, (2) opens a specific workbook file, and sortakinda makes it visible. Screen becomes visible for that workbook, but blank.
Next would be to open a particular Sheet and make that visible, because unless it's visible Access cannot do the things it needs to with the Excel data.
This was working fine before the recent upgrade, but now the last part fails with a "Subscript out of range" error. No clue why. Any ideas, all y'all?
Have also posted this over in the Excel Forums.