Re: $$Excel-Macros$$ 2003 to 2007 : VBA Code
Thanks! :) On Wed, Jun 22, 2011 at 9:18 PM, ashish koul wrote: > try this > > http://peltiertech.com/Excel/Charts/ > > > On Wed, Jun 22, 2011 at 7:56 PM, Chandra Shekar < > chandrashekarb@gmail.com> wrote: > >> 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 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 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 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 wrote:* >>>>> *** >
Re: $$Excel-Macros$$ 2003 to 2007 : VBA Code
try this http://peltiertech.com/Excel/Charts/ On Wed, Jun 22, 2011 at 7:56 PM, Chandra Shekar < chandrashekarb@gmail.com> wrote: > 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 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 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 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 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é
Re: $$Excel-Macros$$ 2003 to 2007 : VBA Code
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 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 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 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 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 (84005'): >>> The specified dimension is not valid for the current chart type. >>> >>>
Re: $$Excel-Macros$$ 2003 to 2007 : VBA Code
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 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 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 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 (84005'): >> 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 >> >> <><><><><><><><><><><><
Re: $$Excel-Macros$$ 2003 to 2007 : VBA Code
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 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 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 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 (84005'): > 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 > > <><><><><><><><><><><><><><><><><><><><
RE: $$Excel-Macros$$ 2003 to 2007 : VBA Code
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 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 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 (84005'): 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 <http://www.excel-macros.blogspot.com/> 4. Learn VBA Macros at http://www.quickvba.blogspot.com <http://www.quickvba.blogspot.com/> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com <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 <http://www.excel-macros.blogspot.com/> 4. Learn VBA Macros at http://www.quickvba.blogspot.com <http://www.quickvba.blogspot.com/> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com <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 <http://www.excel-macros.blogspot.com/> 4. Learn VBA Macros at http://www.quickvba.blogspot.com <http://www.quickvba.blogspot.com/> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com <http://exceldailytip.blogspot.com/> To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook
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 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 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 (84005'): > 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 > h
RE: $$Excel-Macros$$ 2003 to 2007 : VBA Code
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 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 (84005'): 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 <http://www.excel-macros.blogspot.com/> 4. Learn VBA Macros at http://www.quickvba.blogspot.com <http://www.quickvba.blogspot.com/> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com <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 <http://www.excel-macros.blogspot.com/> 4. Learn VBA Macros at http://www.quickvba.blogspot.com <http://www.quickvba.blogspot.com/> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com <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
RE: $$Excel-Macros$$ 2003 to 2007 : VBA Code
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 (84005'): 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