$$Excel-Macros$$ Re: Change FROM email address

2009-11-21 Thread Hanum
I domt see .From property defined anywhere. I did try with SendName property but the code errors out. Any further help is greatly appreciated. Dim myMail As MailItem 'All 'my 'code With myMail .To = "myn...@myadd.com" '.From = .Subject = "My files"

Re: $$Excel-Macros$$ Re: Count of Text

2009-11-21 Thread Aindril De
Attach a file in reply to this email.. On Fri, Nov 20, 2009 at 3:55 PM, mahavir wrote: > > i dont know how to attached file. pls tell me the procedure > > Mahavir > > > On Nov 19, 10:50 pm, mahavir wrote: > > Pls help > > -- > > --

$$Excel-Macros$$ Re: Count of Text

2009-11-21 Thread mahavir
i dont know how to attached file. pls tell me the procedure Mahavir On Nov 19, 10:50 pm, mahavir wrote: > Pls help -- -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-

Re: $$Excel-Macros$$ Urgent Help Needed

2009-11-21 Thread Nandkumar kakvipure
send file On Sat, Nov 21, 2009 at 7:29 AM, sheetallakho...@gmail.com < sheetallakho...@gmail.com> wrote: > Hi Friends, > > Is there anyway to remove or crack the VBA password from the an excel > file. As soon as u double click to open the file. It gives a message > that Enter password for write a

RE: $$Excel-Macros$$ Add a column of matching numbers

2009-11-21 Thread Dave Bonallack
Hi Mike, Try this code. It may be quicker. But it won't go to the end of Col B if Col B has any blank cells. Let me know if this is a problem. Sub NumColA() Columns("A:A").Insert Shift:=xlToRight Range("A1") = 1: Range("A2") = 2 Range("A1:A2").AutoFill Destination:=Range(Cells(1, 1),