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:excel-macros@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
