Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

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

Posted on 2016-08-31
5
Medium Priority
?
245 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
3 Comments
 
LVL 36

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

Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

Question has a verified solution.

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

The Windows Phone Theme Colours is a tight, powerful, and well balanced palette. This tiny Access application makes it a snap to select and pick a value. And it doubles as an intro to implementing WithEvents, one of Access' hidden gems.
Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc. In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
Suggested Courses

577 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