RE: $$Excel-Macros$$ Macro that sends email with an attachment of current excel doc in lotus - Help!

2011-12-22 Thread Asa Rossoff
I don't know much about Lotus Notes or automating it, but you don't Set Session to anything. You'll need to do that before your Set Maildb (first command) line. Asa -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of NJIBA Sent: Thur

Re: $$Excel-Macros$$ List all Excel Workbooks

2011-12-22 Thread Cab Boose
Hi After about 3 minutes (30Gig on hardrives) it came up with: Run-time error '-2144010224 (803500 10)': Method 'Execute' of object 'FileSearch' failed Your comments would be appreciated. Thanks Charlie Harris On Fri, Dec 23, 2011 at 5:28 PM, siti Vi wrote: > Hi Charlie, > Plea

$$Excel-Macros$$ Macro that sends email with an attachment of current excel doc in lotus - Help!

2011-12-22 Thread NJIBA
So I used the VB below and I fell in an abyss. I know it's not working because I do not get an email but I dont get an error message either. Any suggestion will be welcome. Dim Maildb As Object Dim MailDoc As Object Dim Body As Object Dim Session As Object 'Open the Mail Data

RE: $$Excel-Macros$$ Return More than 1 value from Function

2011-12-22 Thread Asa Rossoff
Hi Hanumant, Yes, similar but simpler. A user-defined type looks much like a class/object in VBA usage, but has fewer features ands doesn't require Set commands to associate a variable with it or the New keyword for creating instances. The major uses for user-defined types at least historically,

Re: $$Excel-Macros$$ List all Excel Workbooks

2011-12-22 Thread siti Vi
Hi Charlie, Please check and try this code, if it helps... '---standard Module- Sub *GenerateList*() ' sitiVi / jakarta 23 Dec 2011 ' in answering: ' http://groups.google.com/group/ _ ' excel-macros/browse_thread/thread/9dbda650f1d09d65# '

$$Excel-Macros$$ Re: Complex Macros

2011-12-22 Thread HarryP Knuckles
If I can help by rolling up my question. Is: Is it possible to build a macro that can complete the following objectives: 1) Match two files (from two different directories x,y on a network) from a list made in excel (vlookup?). 2) Rename the new workbook i.e. Richard CR006 V2.xls and worksheet

$$Excel-Macros$$ List all Excel Workbooks

2011-12-22 Thread Cab Boose
Hi There are plenty of solutions for listing open excel files. I would like to list all excel workbooks on my C: and F: drives. They are all over the place. My bad housekeeping! How do I get the complete address for each workbook ? either with a hyperlink or not. But do need to print out t

$$Excel-Macros$$ Complex Macros

2011-12-22 Thread HarryP Knuckles
Good afternoon Folks, I have two directories of excel files (Part 1 and Part 2) that contain the same information except the second directory (part 2’s) contains newer information than the first directory (part 1’s). I have a list embedded into a worksheet of m

Re: $$Excel-Macros$$ Copy multiples tables from one worksheet to separate worksheets

2011-12-22 Thread Mahesh parab
Hi Try : Sub Mtest() Dim ws2 As Worksheet Dim c As Range For Each c In Range("A1:A" & Cells(Rows.Count, 1).End(xlUp).Row) If c.MergeCells Then c.CurrentRegion.Copy Set ws2 = Worksheets.Add(After:=Sheets(Sheets.Count)) With ws2 .Name = c.Value .Range("A1

RE: $$Excel-Macros$$ VBA Helps

2011-12-22 Thread Excel_Lover
Hi Please see the attached Sheet. Hope it will Help Rajan. -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of RockyFontane Sent: 22 December 2011 21:56 To: MS EXCEL AND VBA MACROS Subject: $$Excel-Macros$$ VBA Helps I have 3 Combo B

RE: $$Excel-Macros$$ reference vlookup sheets

2011-12-22 Thread Excel_Lover
See the attached File Rajan. -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of dguillett1 Sent: 22 December 2011 21:14 To: MS EXCEL AND VBA MACROS Subject: Re: $$Excel-Macros$$ reference vlookup sheets You shouldn't need code here

$$Excel-Macros$$ JOB (Excel/Access VBA, 2-3 yrs experience, Ernst & Young)

2011-12-22 Thread Ayush Jain
Hi, We urgently need some Excel and Access VBA developers with upto 2-3 yrs of experience and good communication skills. Please send me resumes of your friends, colleagues and yours @ jainayus...@gmail.com Thanks. Best regards, Ayush Jain Microsoft MVP Group Manager -- FORUM RULES (934+ members

Re: $$Excel-Macros$$ reference vlookup sheets

2011-12-22 Thread NOORAIN ANSARI
Dear selva, Please see attached sheet to use vlookup in different Sheet. On Thu, Dec 22, 2011 at 5:32 AM, Selva wrote: > > the follwoing is the code i;m using to reference 7 sheets into a > master list, the problem i'm running into is the vlookup it's selva > > i need B2 to loop ie once the fir

Re: $$Excel-Macros$$ VBA Helps

2011-12-22 Thread NOORAIN ANSARI
Dear Rocky, Please see attached Sheet. -- Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/* *http://noorain-ansari.blogspot.com/* On Thu, Dec 22, 2011 at 10:45 PM, RockyFontane wrote: > Thank yo

Re: $$Excel-Macros$$ Return More than 1 value from Function

2011-12-22 Thread hanumant shinde
sorry i didnt understand what you mean.   can somebody please help me with this. From: dguillett1 >To: excel-macros@googlegroups.com >Sent: Wednesday, 21 December 2011 9:33 PM >Subject: Re: $$Excel-Macros$$ Return More than 1 value from Function > > >homework?? > >Don Guillett >SalesAid Softwar

Re: $$Excel-Macros$$ VBA Helps

2011-12-22 Thread RockyFontane
Thank you for the quick turn around. Apologize if my request was unclear. Using your spreadsheet, if A1 is equal to 1, I only want to see ComboBox 1. If it's equal to 2, then only show Combo2, etc. Can that be done? On Dec 22, 12:03 pm, NOORAIN ANSARI wrote: > Dear Rocky, > > Please see attac

Re: $$Excel-Macros$$ Return More than 1 value from Function

2011-12-22 Thread hanumant shinde
Thanks a lot Asa,   I think this might be some what smilar to class thing. just a guess     From: Asa Rossoff >To: excel-macros@googlegroups.com >Sent: Thursday, 22 December 2011 3:04 AM >Subject: RE: $$Excel-Macros$$ Return More than 1 value from Function > > >I won't tackle classes right now,

Re: $$Excel-Macros$$ VBA Helps

2011-12-22 Thread NOORAIN ANSARI
Dear Rocky, Please see attached sheet, I hope your requirement is this. -- Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/* *http://noorain-ansari.blogspot.com/* On Thu, Dec 22, 2011 at 9:56 PM,

$$Excel-Macros$$ VBA Helps

2011-12-22 Thread RockyFontane
I have 3 Combo Boxes. 1, 2 and 3. I only want #1 to show when the value in A1 equals 1; 2 to show when the value in A1 equals 2 and 3 to show if the value in A1 equals 3. Can you help me with that code? -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread

Re: $$Excel-Macros$$ Searching DOUBT

2011-12-22 Thread dguillett1
File attached Don Guillett SalesAid Software dguille...@gmail.com From: SAJID MEMON Sent: Thursday, December 22, 2011 1:10 AM To: Sundarvelan Natarajan Subject: $$Excel-Macros$$ Searching DOUBT Dear Ex

Re: $$Excel-Macros$$ reference vlookup sheets

2011-12-22 Thread dguillett1
You shouldn't need code here. Look in the HELP index for INDIRECT and apply to your vlookup formula Don Guillett SalesAid Software dguille...@gmail.com -Original Message- From: Selva Sent: Wednesday, December 21, 2011 6:02 PM To: MS EXCEL AND VBA MACROS Subject: $$Excel-Macros$$ refere

$$Excel-Macros$$ Vba code required

2011-12-22 Thread KAUSHIK SAVLA
Hi, I am looking for solution to below:- I receive No. of emails from some people asking for tax advise in Outlook 2003. Then I create tax advice and I attach the file. I need to reply to the email received below:- Hi *Sender*(as per email), As requested, please find attached below payslip s

$$Excel-Macros$$ Need assistance in calculating FD intrest in excel

2011-12-22 Thread santosh subudhi
Hi Group, I am trying to calculate the interest in excel for a fixed deposit I have done in a leading bank with Investment Amt 30,000/- ROI 9.6% Period 500 days (16 months and 12 days) Maturity value is 34,159.00/- Compounded Quarterly I am currently referring this link http://www.allbankingsolu

Re: $$Excel-Macros$$ For Excel Beginner, please try this test...

2011-12-22 Thread Chuka Lkh
please attach file On Tue, Dec 20, 2011 at 10:58 PM, Vikash Chandra wrote: > Dear Ravi, > I didnt find any attachment.Please send it once again. > Thanks & Regards, > Vikash Chandra > Bangalore > 9902622922 > > On Mon, Dec 19, 2011 at 12:19 PM, Ravinder Negi > wrote: > > For Excel Beginner, plea