Solved

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

Posted on 2013-06-17
5
1,393 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

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

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…
Access custom database properties are useful for storing miscellaneous bits of information in a format that persists through database closing and reopening.  This article shows how to create and use them.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

732 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