Solved

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

Posted on 2016-08-31
5
86 Views
Last Modified: 2016-09-01
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"
0
Comment
Question by:donhannam
  • 2
5 Comments
 
LVL 33

Expert Comment

by:Norie
ID: 41779219
Where exactly does the code fail?
0
 

Author Comment

by:donhannam
ID: 41779222
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
 

Accepted Solution

by:
donhannam earned 0 total points
ID: 41779264
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

Featured Post

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Most if not all databases provide tools to filter data; even simple mail-merge programs might offer basic filtering capabilities. This is so important that, although Access has many built-in features to help the user in this task, developers often n…
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

910 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now