Re: $$Excel-Macros$$ Email Sheet with message

2012-03-13 Thread NOORAIN ANSARI
Please add Outlook library before run the code Tools-Reference-Microsoft Outlook 12.0 Object Library. -- Thanks & regards, Noorain Ansari *http://noorainansari.com/* *http://excelmacroworld.blogspot.com/* On Wed, Mar 1

Re: $$Excel-Macros$$ Email Sheet with message

2012-03-13 Thread NOORAIN ANSARI
Dear Selva, Please use below code to add message Sub Send_Email() Dim olApp As Outlook.Application Dim olMail As MailItem Dim mailbody As String Set olApp = New Outlook.Application Set olMail = olApp.CreateItem(olMailItem) With olMail .To = "noorain.ans...@gmail.com" .CC = "noorain.ans...@one97.n

$$Excel-Macros$$ Email Sheet with message

2012-03-13 Thread LearnExcel
i'm using the following code to send email how do i add something to the body? does anyone know if its possible to add a message to the email? ThisWorkbook.Sheets(1).Copy With ActiveWorkbook .SendMail Recipients:="emailaddr...@df.com", _ Subject:="Try Me")

RE: $$Excel-Macros$$ Goal Seek option from Tools menu....(little urgent)

2012-03-13 Thread Mohammed Muneer
U r Welcome! Regards, Muneer, CC.. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Ferry H Sitohang Sent: Tuesday, March 13, 2012 3:27 PM To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ Goal Seek opt

$$Excel-Macros$$ Divide Results from 2 Pivot Tables

2012-03-13 Thread Jim
I'm trying to divide a value in one Pivot Table by a value in a second Table. Please see the screen shot and the following explanation in the attached Word document. Any ideas? I'm thinking that I may be missing a very obvious alternate to solving this problem: "The YTD Booking Rate isn’t the s

Re: $$Excel-Macros$$ Turn Tab Order on/off

2012-03-13 Thread Cab Boose
Hi Asa At the moment the H1 setting makes no difference. The sheet works like normal with the setting at activate or deactivate, and not in tab order. Thanks Charlie On Sun, Mar 4, 2012 at 10:09 PM, Asa Rossoff wrote: > Hi Charlie, > > The "button" is actually just a cell that is colore

Re: $$Excel-Macros$$ Saving Excel Macro file to Xls format

2012-03-13 Thread dguillett1
Just save it as .xls and hope that your macros are BACKWARD compatible. Some are NOT. Test! Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com -Original Message- From: Avinash Daga Sent: Tuesday, March 13, 2012 10:55 AM To: excel-macros@googlegroups.com Subject:

Re: $$Excel-Macros$$ Help Needed

2012-03-13 Thread BNS kumar
Hi, Please find the attached text file. Copy and paste in that excel file and run. Regards Kumar On Tue, Mar 13, 2012 at 2:08 PM, Patil MG wrote: > Hi All > > can any one help me pl..its very urgent,,, > > > On Mon, Mar 12, 2012 at 12:52 PM, Patil MG wrote: > >> Dear Exper

Re: $$Excel-Macros$$ Help Needed

2012-03-13 Thread BNS kumar
Hi, check this out Sub CreateWordDocs() ' add a reference to the Word-library ' this is for creating number word Documents and renaming them with file names mentioned in 'C' column ' this code doesn't write any content, it just creates word documents and saves them Dim newapp As

$$Excel-Macros$$ Saving Excel Macro file to Xls format

2012-03-13 Thread Avinash Daga
How can I save excel macro file (.XLSM) file to XLS format? and macro still working in that file? Thanks and Regards, Avinash Daga -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formul

Re: $$Excel-Macros$$ Format data from Tally 7.2

2012-03-13 Thread dguillett1
I thought I already responded to this. Sub CopyColumnsToTableSAS() Dim i As Integer Dim fr As Long Dim lr As Long 'col A Cells(2, 1).Resize(Cells(2, 1).End(xlDown).Row).Copy Cells(2, "g") 'other columns For i = 2 To 5 fr = Cells(2, i).End(xlDown).Row lr = Cells(Rows.Count, i).End(xlUp).Row Cells

Re: $$Excel-Macros$$ Macro for format table

2012-03-13 Thread dguillett1
Should do it Sub CopyColumnsToTableSAS() Dim i As Integer Dim fr As Long Dim lr As Long 'col A Cells(2, 1).Resize(Cells(2, 1).End(xlDown).Row).Copy Cells(2, "g") 'other columns For i = 2 To 5 fr = Cells(2, i).End(xlDown).Row lr = Cells(Rows.Count, i).End(xlUp).Row Cells(fr, i).Resize(lr).Copy Cel

$$Excel-Macros$$ Macro for format table

2012-03-13 Thread Rajesh K R
Hi experts Find the attached file,and help me to create a macro to format a table from the data given. My idea to solve this select column A:E, & paste in G1 Select blank cells in column B ,here B2:B26 & Deletethem Repeat the sale in next columns Regards Rajesh Kainikkara -- FORUM

Re: $$Excel-Macros$$ Format data from Tally 7.2

2012-03-13 Thread Rajesh K R
Hi Thanks for ur reply, but i need a format like which add in attached file. Regards Rajesh Kainikkara On 3/13/12, Aivi wrote: > PFA.. > > ReGaRdS > AiVrAn kUmAr > > On Tue, Mar 13, 2012 at 9:46 AM, Rajesh K R > wrote: > >> Hi experts, >> >> I have a large data in Tally 7.2,when i try to I got

Re: $$Excel-Macros$$ Logical Formula Problem

2012-03-13 Thread hilary lomotey
thanks Don On Mon, Mar 12, 2012 at 7:39 PM, dguillett1 wrote: > See if this simpler approach is helpful > > > Don Guillett > Microsoft MVP Excel > SalesAid Software > dguille...@gmail.com > > *From:* hilary lomotey > *Sent:* Monday, March 12, 2012 10:22 AM > *To:* excel-macros > *Subject:*

Re: $$Excel-Macros$$ Help Needed

2012-03-13 Thread Patil MG
Hi All can any one help me pl..its very urgent,,, On Mon, Mar 12, 2012 at 12:52 PM, Patil MG wrote: > Dear Experts, > > I have to create 'N' number of empty files of word and note pad files, > this word will long time to do can any one help to write a macro where in > which