• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 267
  • Last Modified:

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")
Set Sheet = xlObj.ActiveWorkbook.Sheets(1)
Sheet.Cells(1, 1).Value = "Heading"
  • 2
1 Solution
NorieVBA ExpertCommented:
Where exactly does the code fail?
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.
donhannamAuthor 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.
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.

Join & Write a Comment

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now