RE: $$Excel-Macros$$ Export of Personal Macro Book

2011-08-15 Thread Amit Desai (MERU)
This one helped thanks... Best Regards, Amit Desai From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Venkat CV Sent: Tuesday, August 16, 2011 11:41 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Export of Personal Macro Book Hi Amit, S

Re: $$Excel-Macros$$ Export of Personal Macro Book

2011-08-15 Thread Venkat CV
*Hi Amit,* * * *See the below path* * * *C:\Documents and Settings\vcc7328\Application Data\Microsoft\Excel\XLSTART\PERSONAL.XLSB* * * *Login ID:vcc7328* * * *For 2007 &2010...* *Best Regards,* *Venkat * *Chennai* * * On Tue, Aug 16, 2011 at 11:33 AM, NOORAIN ANSARI wrote: > Dear Amit, > > P

Re: $$Excel-Macros$$ Export of Personal Macro Book

2011-08-15 Thread NOORAIN ANSARI
Dear Amit, Please find full fath of Personal Macro File.. 1. C:\Program Files\Microsoft Office\Office12\XLSTART 2. Press Alt+F11, Go to File-Import Option to Transfer Macro file. Thanks & regards, Noorain Ansari On Tue, Aug 16, 2011 at 11:13 AM, Amit Desai (MERU) wrote: > Dear Masters

Re: $$Excel-Macros$$ Export of Personal Macro Book

2011-08-15 Thread Sanjib Chatterjee
you can find it in personal.xls file in you system. Which is stays in \Microsoft Office\xlstart folder. copy it and paste in you new location On 8/16/11, Amit Desai (MERU) wrote: > Dear Masters, > > I am currently using a temporary laptop & in few days will receive another > one. I have created

$$Excel-Macros$$ Export of Personal Macro Book

2011-08-15 Thread Amit Desai (MERU)
Dear Masters, I am currently using a temporary laptop & in few days will receive another one. I have created some Macros & saved them in personal macro workbook. My queries are; 1) Where to find them on my system, 2) How to transfer them to new system. Best Regards, Amit Desai

Re: $$Excel-Macros$$ Notes : Help

2011-08-15 Thread ashish koul
can you attach your file On Mon, Aug 15, 2011 at 5:35 PM, Chandra Shekar < chandrashekarb@gmail.com> wrote: > Hi, > > I am getting attached error while running the macro. Please let me know > whats the error in the below code. > > *MailDoc.Save True, True, False* > > Regards, > > Chandra Sh

Re: $$Excel-Macros$$ Fwd: Job opening

2011-08-15 Thread Venkat CV
Hi Praksah, Please forward in to this ID: ma...@bhilwarainfo.com *Best Regards,* *Venkat * *Chennai* On Sun, Aug 14, 2011 at 9:18 PM, prakash prakash wrote: > hi, > > please find the attached file > regards > gnanaprakash n > > > On Wed, Aug 10, 2011 at 3:05 PM, Venkat CV wrote: > >>

Re: $$Excel-Macros$$ Looking for MIS training in Bangalore (Complete Excel and VBA Courses)

2011-08-15 Thread NOORAIN ANSARI
http://chandoo.org/wp/excel-school/ http://chandoo.org/wp/vba-classes/ On Mon, Aug 15, 2011 at 11:56 AM, Puttu wrote: > Hi Experts, > > I want to learn excel, VBA in bangalore, I have basic knowledge in > both. Please advise any complete training institues where I can learn > and became master o

Re: $$Excel-Macros$$ Over Time

2011-08-15 Thread Excel VBASQL
We can help email us at excelvba...@gmail.com On Aug 14, 8:34 am, sheron joseph wrote: > Excellent Mr.Rajan Verma..Superb > > > From: Rajan_Verma > To: excel-macros@googlegroups.com > Sent: Sunday, 14 August 2011 4:14 PM > Subject: RE: $$Excel-Macros$$ Over Time

Re: $$Excel-Macros$$ Looking for MIS training in Bangalore (Complete Excel and VBA Courses)

2011-08-15 Thread Excel VBASQL
Hi Putta, www.ExcelVBASql.com has over 27+ hours of FREE videos for you to watch and learn VBA to become an EXPERT. Start watching today! On Mon, Aug 15, 2011 at 1:26 AM, Puttu wrote: > Hi Experts, > > I want to learn excel, VBA in bangalore, I have basic knowledg

RE: $$Excel-Macros$$ To get a graphic item of size equal to a cell entry

2011-08-15 Thread Daniel
HI, Paste this macro in the sheet module : Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address <> "$A$1" Or Target.Count <> 1 Then Exit Sub With Sheets("Sheet1") .Shapes(1).Width = .[B1].Offset(, .[A1].Value - 1).Left End With End Sub Regards. Daniel -

Re: $$Excel-Macros$$ Notes : Help

2011-08-15 Thread Chandra Shekar
Hi Asish, Thank u for the help again I am getting error in the below code. Please let me know whats the problem in the below code. Thanks in advance. ** *MailDoc.Save True, True, False * On Mon, Aug 15, 2011 at 9:53 AM, ashish koul wrote: > dont use .copy in set statement > > > On Fri, Aug 12,

Re: $$Excel-Macros$$ Looking for MIS training in Bangalore (Complete Excel and VBA Courses)

2011-08-15 Thread ashish koul
online ms excel certifications http://www.microsoft.com/learning/en/us/certification/mos.aspx#certifications excel video tutorials http://www.youtube.com/user/ExcelIsFun http://www.youtube.com/user/freetutorials#p/c/101B97B62F3B2586/0/FNPNS6MT1Kk http://www.youtube.com/user/MotionTraining ht

Re: $$Excel-Macros$$ Notes : Help

2011-08-15 Thread ashish koul
dont use .copy in set statement On Fri, Aug 12, 2011 at 3:43 PM, Chandra Shekar < chandrashekarb@gmail.com> wrote: > Hello Ashish, > > I got solution for this issue but I am getting one more error in code as > type mismatch > > > *Set rnbody1 = Sheets("Details").UsedRange.Copy > rnbody1.Copy