using CreateObject("Excel.Application") in Access 2010 run time - not working when Excel 2016 installed
Posted on 2016-08-31
Hi, I have Access 2010 adp application which uses late binding to create Excel spreadsheets which I have used as some clients have different versions of Excel. All been working fine for years.
I now have a client that has only office 365 - Excel 2016 on their PC - I am getting error "the format you are attempting to output the current object is not available" when creating Excel.
The have access 2010 runtime installed and possibly may have a 64 bit version of Office 365.
Does anyone have any ideas to get around this?.
Extract of code:-
Set xlObj = CreateObject("Excel.Application")
Set Sheet = xlObj.ActiveWorkbook.Sheets(1)
Sheet.Cells(1, 1).Value = "Heading"