Pleaase can I get 2007 code to get good looking chart as 2003. Thanks! On Wed, Jun 22, 2011 at 2:04 PM, ashish koul <koul.ash...@gmail.com> wrote:
> 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 > -- ---------------------------------------------------------------------------------- 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
