Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro 2003 error 2007
We have a Excel sheet that loads raw data from csv files.
On excelö 2003 and below works perfectly but on 2007 we get application or object defined error. When calling OnAction from ChartObjects, I'd tried to find a soilution and so far none has been satisfactry, Is ther a way not to recode and use a kind of compatibility mode... IS quite annoing that former versions of OFFICE cant be supported. example :----- Option Explicit Private Sub Worksheet_Activate() Dim ch_ As ChartObject For Each ch_ In Me.ChartObjects ch_.OnAction = "'" & ThisWorkbook.Name & "'!Cover.ZoomChart" Next ch_ Range("B3").Select End Sub |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro 2003 error 2007
Has someone any IDEA why excel 2007 does not run code made on 2003?
How i can enable the OnAction it says it does not exist, if open the same on excel 2003 an below works fine but on 2007 error appears. Any HELP ? "MS GVE" wrote: We have a Excel sheet that loads raw data from csv files. On excelö 2003 and below works perfectly but on 2007 we get application or object defined error. When calling OnAction from ChartObjects, I'd tried to find a soilution and so far none has been satisfactry, Is ther a way not to recode and use a kind of compatibility mode... IS quite annoing that former versions of OFFICE cant be supported. example :----- Option Explicit Private Sub Worksheet_Activate() Dim ch_ As ChartObject For Each ch_ In Me.ChartObjects ch_.OnAction = "'" & ThisWorkbook.Name & "'!Cover.ZoomChart" Next ch_ Range("B3").Select End Sub |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
excel compatibility macro 2003 error 2007
Anyone can help Please why Microsoft does not give backwards compatibility?
At least by now we are now recommending our customers using the application not to upgrade to 2007, due we have not got response of this. Please anyone whom might help explainning the issue (see code) and how wwe can make it work with minimal modification or if there is a plugin or feature where to enable 2003 excel versions run on 2007 i've tried to convert the app and no luck. Thanks in advance "MS GVE" wrote: We have a Excel sheet that loads raw data from csv files. On excelö 2003 and below works perfectly but on 2007 we get application or object defined error. When calling OnAction from ChartObjects, I'd tried to find a soilution and so far none has been satisfactry, Is ther a way not to recode and use a kind of compatibility mode... IS quite annoing that former versions of OFFICE cant be supported. example :----- Option Explicit Private Sub Worksheet_Activate() Dim ch_ As ChartObject For Each ch_ In Me.ChartObjects ch_.OnAction = "'" & ThisWorkbook.Name & "'!Cover.ZoomChart" Next ch_ Range("B3").Select End Sub |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
excel compatibility macro 2003 error 2007
I have had no problems at all using workbooks created in 2003 in 2007,
nor have I had problems using workbooks created in 2007 in 2003 (assuming they don't implement features new to 2007). If you don't intend on using any of the new features of 2007, you can just open the 2003 workbook in 2007 and 2007 will enter compatibility mode. Changes made in 2007, as long as those features exist in 2003, will be available when you open the workbook later in 2003. MS also has a compatibility pack that allows you to open 2007 workbooks within 2003. In this case, of course, you can't use any new 2007 features, but you'll have full 2003 functionality in a 2007 workbook. Just for testing, I created a workbook in 2003 with a single ChartObject on Sheet1 and then ran the following code: Sub AAA() Dim ChtObj As ChartObject Set ChtObj = ThisWorkbook.Worksheets(1).ChartObjects(1) ChtObj.OnAction = "TestMe" End Sub Sub TestMe() MsgBox "hello" End Sub When I click on the ChartObject, I get the message box. Then, I created an identical workbook in 2007, saved it as a 2003 compatible workbook, opened it in 2003, and everything worked as expected. In short, MS does indeed provide backwards compatibility (you can still use XLM, for God's sake, that was made obsolete nearly 15 years ago). I cannot replicate the problem you report. If you want, you can email the workbook to and I'll have a look at it. Cordially, Chip Pearson Microsoft Most Valuable Professional Excel Product Group, 1998 - 2009 Pearson Software Consulting, LLC www.cpearson.com (email on web site) On Fri, 28 Aug 2009 02:45:02 -0700, GVE wrote: Anyone can help Please why Microsoft does not give backwards compatibility? At least by now we are now recommending our customers using the application not to upgrade to 2007, due we have not got response of this. Please anyone whom might help explainning the issue (see code) and how wwe can make it work with minimal modification or if there is a plugin or feature where to enable 2003 excel versions run on 2007 i've tried to convert the app and no luck. Thanks in advance "MS GVE" wrote: We have a Excel sheet that loads raw data from csv files. On excelö 2003 and below works perfectly but on 2007 we get application or object defined error. When calling OnAction from ChartObjects, I'd tried to find a soilution and so far none has been satisfactry, Is ther a way not to recode and use a kind of compatibility mode... IS quite annoing that former versions of OFFICE cant be supported. example :----- Option Explicit Private Sub Worksheet_Activate() Dim ch_ As ChartObject For Each ch_ In Me.ChartObjects ch_.OnAction = "'" & ThisWorkbook.Name & "'!Cover.ZoomChart" Next ch_ Range("B3").Select End Sub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
xls(2003) macro.. make error in 2007 office event ID 1000 | Setting up and Configuration of Excel | |||
2003 created Workbook casuses error when macro runs in 2007 | Excel Programming | |||
2003 macro generates compiler error on 2007 | Excel Worksheet Functions | |||
Error transporting excel 2007 macro to excel 2003. | Excel Programming | |||
Unexpected Error in 2003 for 2007 | Setting up and Configuration of Excel |