Solved

Excel/Access 2007/2010 vba chart error "specified dimension is not valid"

Posted on 2013-06-17
5
1,406 Views
Last Modified: 2013-06-22
I have a procedure in Access 2010 that creates a spreadsheet and adds some data and charts. This works correctly in Access 2010, but when I run it in Access 2007 with Excel 2007, upon saving I get the error "the specified dimension is not valid for the current chart type." I have tried saving in different Excel formats, but all return the same error.

Does anybody have any idea why a procedure that works as intended with Access 2010 would be returning this error when run in Access 2007?
0
Comment
Question by:dgmoore1
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
5 Comments
 
LVL 120

Accepted Solution

by:
Rey Obrero (Capricorn1) earned 167 total points
ID: 39253397
it could be a compatibility issue...
upload a copy of the A2007 version.
0
 
LVL 21

Assisted Solution

by:Boyd (HiTechCoach) Trimmell, Microsoft Access MVP
Boyd (HiTechCoach) Trimmell, Microsoft Access MVP earned 333 total points
ID: 39253857
It is probably a backward compatibility issue.

You really should develop and test in the lowest version of Office you want to support. You will need to make sure that your code will run with 2007. I find that id I write code that will work in  2007 that is will also work fine in  2010. But not the other way around.

NOTE: Excel 2010 has new features exposed in he object model (available in VBA)  that are not available in 2007.

also see:

http://www.rondebruin.nl/win/s5/win002.htm

Working with the Compatibility Checker in Excel 2007 and Excel 2010
http://msdn.microsoft.com/en-us/library/office/gg132972%28v=office.14%29.aspx
http://office.microsoft.com/en-us/excel-help/worksheet-compatibility-issues-HA010343040.aspx
0
 

Author Comment

by:dgmoore1
ID: 39254314
I agree that I should be developing in the version my users have, but our CIO insists that developers lead the way (as guinea pigs) with upgraded applications, so we have to use versions that are ahead of our users, unfortunately.
0
 
LVL 21

Assisted Solution

by:Boyd (HiTechCoach) Trimmell, Microsoft Access MVP
Boyd (HiTechCoach) Trimmell, Microsoft Access MVP earned 333 total points
ID: 39268193
WOW. Unfortunately the makes it very difficult to support Office/VBA applications in prior versions.

Sounds like you will have to do a lot of testing to see what features are backwardly compatible.

Hope you are paid by the hour.
0
 

Author Comment

by:dgmoore1
ID: 39268321
The company is rolling out Office 2010 as assets are replaced. When a box goes back on lease return its replacement has Win 7 and Office 2010 installed. We're talking thousands of workstations at numerous locations, so it's going to take a while to get everybody on the same page. The vast majority of users only need a browser, Word and maybe Excel to do their jobs, but there are scattered requirements for other tools and custom applications.

Fortunately, if there is an ad hoc requirement for Office 2010 we can get it installed, which is what I did this week to solve my current problem. I seem to be the lucky guy who runs into obscure issues because I'm usually building stuff that nobody else does, so we don't have much of a knowledge base.
0

Featured Post

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

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

Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

724 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