Sub check() If Application.Version = "12.0" Then
' code for 2007 End If If Application.Version = "11.0" Then 'code for 2003 End If End Sub On Wed, Jun 22, 2011 at 11:15 AM, Chandra Shekar < chandrashekarb....@gmail.com> wrote: > Hi, > > Can we write different code do this. Where VBA code knows which version > user is using according to that it changes chart plot area. If yes please > let me know. Thanks! > > On Wed, Jun 22, 2011 at 12:34 AM, Daniel <dcolarde...@free.fr> wrote: > >> Charts are quite different with Excel2007, so you have to resize the >> plot area, change the series colors in order to get something similar. I use >> Excel 2010 which is still different from Excel 2007.**** >> >> ** ** >> >> Daniel**** >> >> ** ** >> >> *De :* excel-macros@googlegroups.com [mailto: >> excel-macros@googlegroups.com] *De la part de* Chandra Shekar >> *Envoyé :* mardi 21 juin 2011 07:49 >> >> *À :* excel-macros@googlegroups.com >> *Objet :* Re: $$Excel-Macros$$ 2003 to 2007 : VBA Code**** >> >> ** ** >> >> Hi,**** >> >> **** >> >> Graph output is different compare to 2003 and 2007. I have pasted both the >> graphs in "Analysis Sheet". 2003 Ouput is that which is produced in 2003 >> which is perfect, but 2007 output which is pasted just below the data is >> generated in 2007 which is not as 2003 output. **** >> >> **** >> >> Please run this code in both 2003 and 2007 you can find the difference.** >> ** >> >> **** >> >> Thanks,**** >> >> **** >> >> Chandra Shekar**** >> >> On Mon, Jun 20, 2011 at 11:46 PM, Daniel <dcolarde...@free.fr> wrote:**** >> >> Hi,**** >> >> **** >> >> Can you ell which macro is involved and which result is different ?**** >> >> **** >> >> Regards.**** >> >> Daniel**** >> >> **** >> >> *De :* excel-macros@googlegroups.com [mailto: >> excel-macros@googlegroups.com] *De la part de* Chandra Shekar >> *Envoyé :* lundi 20 juin 2011 10:19 **** >> >> >> *À :* excel-macros@googlegroups.com**** >> >> *Objet :* Re: $$Excel-Macros$$ 2003 to 2007 : VBA Code **** >> >> **** >> >> Hi,**** >> >> **** >> >> I am getting different output in 2003 & 2007 I gave pasted that in >> attached workbook. Please let me know if you have any queries regarding >> this. Thanks!**** >> >> **** >> >> Regards,**** >> >> **** >> >> Chandra Shekar B**** >> >> **** >> >> >> >> **** >> >> On Sat, Jun 18, 2011 at 12:05 AM, Daniel <dcolarde...@free.fr> wrote:**** >> >> Hi,**** >> >> **** >> >> I don’t think there are tool to automate the processbecause the syntax is >> very similar. Can you post your code and tell which line produces the error >> ?**** >> >> **** >> >> Regards.**** >> >> Daniel**** >> >> **** >> >> *De :* excel-macros@googlegroups.com [mailto:e >> xcel-mac...@googlegroups.com] *De la part de* Chandra Shekar >> *Envoyé :* vendredi 17 juin 2011 10:13 >> *À :* excel-macros@googlegroups.com >> *Objet :* $$Excel-Macros$$ 2003 to 2007 : VBA Code**** >> >> **** >> >> Hi,**** >> >> **** >> >> How to convert 2003 VBA code to 2007, because some of codes what I am >> running in 2003 is not running in 2007. Is there any way to convert this to >> any office to get the same result.**** >> >> **** >> >> I am getting following error... Run-time error '-2147467259 (800004005'): >> The specified dimension is not valid for the current chart type. **** >> >> Thanks,**** >> >> **** >> >> Chandra Shekar B**** >> >> -- >> >> ---------------------------------------------------------------------------------- >> Some important links for excel users: >> 1. Follow us on TWITTER for tips tricks and links : >> http://twitter.com/exceldailytip >> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >> 3. Excel tutorials at http://www.excel-macros.blogspot.com >> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >> >> To post to this group, send email to excel-macros@googlegroups.com >> >> <><><><><><><><><><><><><><><><><><><><><><> >> Like our page on facebook , Just follow below link >> http://www.facebook.com/discussexcel**** >> >> -- >> >> ---------------------------------------------------------------------------------- >> Some important links for excel users: >> 1. Follow us on TWITTER for tips tricks and links : >> http://twitter.com/exceldailytip >> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >> 3. Excel tutorials at http://www.excel-macros.blogspot.com >> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >> >> To post to this group, send email to excel-macros@googlegroups.com >> >> <><><><><><><><><><><><><><><><><><><><><><> >> Like our page on facebook , Just follow below link >> http://www.facebook.com/discussexcel**** >> >> **** >> >> -- >> >> ---------------------------------------------------------------------------------- >> Some important links for excel users: >> 1. Follow us on TWITTER for tips tricks and links : >> http://twitter.com/exceldailytip >> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >> 3. Excel tutorials at http://www.excel-macros.blogspot.com >> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >> >> To post to this group, send email to excel-macros@googlegroups.com >> >> <><><><><><><><><><><><><><><><><><><><><><> >> Like our page on facebook , Just follow below link >> http://www.facebook.com/discussexcel**** >> >> -- >> >> ---------------------------------------------------------------------------------- >> Some important links for excel users: >> 1. Follow us on TWITTER for tips tricks and links : >> http://twitter.com/exceldailytip >> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >> 3. Excel tutorials at http://www.excel-macros.blogspot.com >> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >> >> To post to this group, send email to excel-macros@googlegroups.com >> >> <><><><><><><><><><><><><><><><><><><><><><> >> Like our page on facebook , Just follow below link >> http://www.facebook.com/discussexcel**** >> >> ** ** >> >> -- >> >> ---------------------------------------------------------------------------------- >> Some important links for excel users: >> 1. Follow us on TWITTER for tips tricks and links : >> http://twitter.com/exceldailytip >> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >> 3. Excel tutorials at http://www.excel-macros.blogspot.com >> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >> >> To post to this group, send email to excel-macros@googlegroups.com >> >> <><><><><><><><><><><><><><><><><><><><><><> >> Like our page on facebook , Just follow below link >> http://www.facebook.com/discussexcel**** >> >> -- >> >> ---------------------------------------------------------------------------------- >> Some important links for excel users: >> 1. Follow us on TWITTER for tips tricks and links : >> http://twitter.com/exceldailytip >> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >> 3. Excel tutorials at http://www.excel-macros.blogspot.com >> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >> >> To post to this group, send email to excel-macros@googlegroups.com >> >> <><><><><><><><><><><><><><><><><><><><><><> >> Like our page on facebook , Just follow below link >> http://www.facebook.com/discussexcel >> > > -- > > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com <http://akoul.blogspot.com/> http://akoul.posterous.com/ *akoul*.wordpress.com <http://akoul.wordpress.com/> My Linkedin Profile <http://in.linkedin.com/pub/ashish-koul/10/400/830> P Before printing, think about the environment. -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel