donhannam
asked on
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.Applic ation")
xlObj.Workbooks.Add
Set Sheet = xlObj.ActiveWorkbook.Sheet s(1)
Sheet.Cells(1, 1).Value = "Heading"
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.Applic
xlObj.Workbooks.Add
Set Sheet = xlObj.ActiveWorkbook.Sheet
Sheet.Cells(1, 1).Value = "Heading"
Where exactly does the code fail?
ASKER
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.
Was hoping someone would know if this is a common issue with 2016.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.