2003-->2007

[Guest]

hi,
i have too problems with macro that i try to work with 2007.
the macro is working in 2003.
i'm not sure if the problems are with the code. it might be somthing with
configurations such as missing DLL.
Please advice:
1)the code :
ActiveSheet.ChartObjects("Chart 95683").Activate
the message -"the item with spesified name not found"
2)the code :
With ws.PageSetup
.CenterFooter = "Page &P of &N"
.RightFooter = "&A"
.LeftMargin = Application.InchesToPoints(0.18)
.RightMargin = Application.InchesToPoints(0.18)
the message:
"unable to set Centerfooter...
"unable to set RightFooter...
"unable to set LeftMargin...
thanks...

 

[Guest]

Hi Miri,

We also had problems with changing some macros from 2003 to 2007. It
appears that some objects such as buttons, charts etc have their names
changed when you save them in 2007.

If you haven't tried it already, double-check that the name of the chart is
still what you expect it to be. The following code works fine for me in 2007
to select 'Chart 1':
ActiveSheet.ChartObjects("Chart 1").Activate

Kind Regards,

Tara H