using CreateObject("Excel.Application") in Access 2010 run time - not working when Excel 2016 installed

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")
xlObj.Workbooks.Add
Set Sheet = xlObj.ActiveWorkbook.Sheets(1)
Sheet.Cells(1, 1).Value = "Heading"
donhannamAsked:
Who is Participating?
 
donhannamConnect With a Mentor Author Commented:
Sorry this question was incorrect - user was trying to convert a report to excel - not the routine I was thinking - Excel 2016 works fine in above situation.
0
 
NorieVBA ExpertCommented:
Where exactly does the code fail?
0
 
donhannamAuthor Commented:
I carn't recreate it on my PC as I have earlier version of Excel but suspect its happening on the create object.

Was hoping someone would know if this is a common issue with 2016.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.