Re: $$Excel-Macros$$ Modify Code to to send range *

Choose In tools ~reference ~ microsoft outlook Sent on my BlackBerry® from Vodafone -Original Message- From: Hilary Lomotey Sender: excel-macros@googlegroups.com Date: Wed, 28 Nov 2012 20:12:36 To: Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Modify Code to t

Re: $$Excel-Macros$$ EMAIL AUTOMATION BY VBA OUTLOOK

> > *Ashish, you are awesome!* > -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quic

$$Excel-Macros$$ Code to refresh information from external data source

Hello Expert can i get help with a code to refresh information coming from a data source. i know the short cut ctrl + alt +f5 to refresh such data, but i would be grateful to get a code to do that thanks -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM

Re: $$Excel-Macros$$ Modify Code to to send range *

Thanks, Ashish for you time. i however get a debug error with this code Sub send_emails(to1 As String, fld1 As String, body1 As String) Dim olApp As Outlook.Application thanks On Tue, Nov 27, 2012 at 3:24 PM, ashish koul wrote: > Sub emailstest() >' run loop here > > Dim bdy As String >

$$Excel-Macros$$ How to determine the volume slabs for different price levels in excel?

I have set of historic data 1. different price levels 2. quantity at that price levels based on the above i need to arrive at the volume slabs like 0-100 units, 100- 300 units etc and also what price needs to be fixed for that slab i would like to know how this can be scientifically done u

Re: $$Excel-Macros$$ small query about conditional formating

try these first http://www.youtube.com/watch?v=LOaezdoyJDE http://www.techrepublic.com/blog/10things/10-cool-ways-to-use-excels-conditional-formatting-feature/3166 http://www.homeandlearn.co.uk/excel2007/excel2007s6p2.html On Wed, Nov 28, 2012 at 10:33 PM, Kenil Gala wrote: > Hi, > Pls help

$$Excel-Macros$$ small query about conditional formating

Hi, Pls help me to solve a small query. i have mentioned the query in the file attached. -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Pr

Re: $$Excel-Macros$$ How to calculate Joining Date from a given job period!!!

Hi,   Pl see the attached sheet.(you can also find the days between two dates)   -R.Karunanithi. From: MRafique Ujjan To: excel-macros@googlegroups.com Sent: Monday, November 26, 2012 4:48 PM Subject: $$Excel-Macros$$ How to calculate Joining Date from a given

Re: $$Excel-Macros$$ Join this Group

I always go to my Google Groups and select from there, so I've never had any trouble "remembering". Either that, or I use the link that you so kindly provide in your sig. for the group. thanks for the update.   Paul - “Do all the good you can, By all the

Re: $$Excel-Macros$$ Re: To automatically display the correct month Min & Max Value

Dear Ashish, Thank you very much for the solutions. Best regards Sanusi On 28 November 2012 23:04, ashish koul wrote: > =INDEX($5:$5,MATCH(C9,$6:$6,0)) > -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titl

Re: $$Excel-Macros$$ Re: To automatically display the correct month Min & Max Value

=INDEX($5:$5,MATCH(C9,$6:$6,0)) On Thu, Nov 22, 2012 at 12:34 PM, Mohd Sanusi Mohd Noor wrote: > > Dear experts, > > > Kindly find attached the excel spreadsheet which i need solution for excel > to automatically display the correct month for the min and max value (as > highlighted in yellow).

Re: $$Excel-Macros$$ Pasting from Excel to Word - Issue with Column Width(s)

Dear Ashish, The columns are fixed. The number of rows is not. The rows are deleted, depending upon whether or not data is entered in them. E.g. sometimes a table may have 20 rows, sometimes 30 and sometimes only 3. To give an idea behind the whole thing: 1. I have a comprehensive word templ

Re: $$Excel-Macros$$ Request for :Hide cell formula & Protect that cell

Hi Protect sheet n keep cell format as locked. Thanks//Vabs Sent on my BlackBerry® from Vodafone -Original Message- From: amar takale Sender: excel-macros@googlegroups.com Date: Wed, 28 Nov 2012 12:42:16 To: Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Request fo

$$Excel-Macros$$ Re: To automatically display the correct month Min & Max Value

Dear experts, Kindly find attached the excel spreadsheet which i need solution for excel to automatically display the correct month for the min and max value (as highlighted in yellow). Your solution/advice on the above is highly appreciated. Thank you Best regards Sanusi -- Join official

$$Excel-Macros$$ Request for :Hide cell formula & Protect that cell

Hi all Champs Can anybody tell me how to protect specific cell & hide that cell formula only.I know how hide it (Format cell-hidden..).No one see that formula & edit that cell only. Regards Amar -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM R

Re: $$Excel-Macros$$ Join this Group

Hi Paul Thanks for your response. www.discussexcel.com is a website link to access this group. This was created by me so that people don't need to remember the full link of Google groups. Regards Ayush Jain On Wed, Nov 28, 2012 at 6:07 PM, Paul Schreiner wrote: > c -- Best regards, Ayush J

Re: $$Excel-Macros$$ Need a Macros to Split spreadsheets

Hi Santhos. Place a folder in desktop. change..according to week.. Sub Macro1() ChDir "C:\Documents and Settings\user\Desktop\week 46" Dim wrksht As Worksheet For Each wrksht In ThisWorkbook.Worksheets wrksht.Select wrksht.Copy ActiveWorkbook.SaveAs Filename:="Account Reciveab

Re: $$Excel-Macros$$ Need a Macros to Split spreadsheets

Hi santhosa, Press Alt +11 Use below --code.. Change accordingly.. Sub Macro1() ChDir "Your Path" Dim wrksht As Worksheet For Each wrksht In ThisWorkbook.Worksheets wrksht.Select wrksht.Copy ActiveWorkbook.SaveAs Filename:= "your path" & wrksht.Name & ".xlsx" ActiveWindow.C

$$Excel-Macros$$ Need a Macros to Split spreadsheets

Hi Friends, Need your help on the below. Please find atatched sample report. 1) Split the tabs into differnt file. 2) Give file name as "Account Reciveable - Tab name" and save it in a specific folder (Week 46). Let me lnow if you are unclear on this. Regards, Santhosh -- Join official Faceb

Re: $$Excel-Macros$$ Join this Group

Manjunath, At the bottom of each email, there is a line: Visit this group at http://groups.google.com/group/excel-macros?hl=en. This link should take you to the group page and liks at the top allow you to sign up. I'm not sure what www . discussexcel . com is Paul

$$Excel-Macros$$ Insert Multiple mails as icons into excel

Hi All, I need to insert multiple mail objects into excel. I have around hundred of mails in a folder in my outlook. I have tried it to save individually and then insert, but its a time consuming process, If you guys can suggest a better way to get this done will be great. Thanks, Waheed -- Joi

RE: $$Excel-Macros$$ Join this Group

Dear Kuldeep, Thank you so much Regards Manjunath From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Kuldeep Singh Sent: 28 November 2012 12:15 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Join this Group Hi Manjunath, http://www.discus

Re: $$Excel-Macros$$ Join this Group

Hi Manjunath, http://www.discussexcel.com/ Open this link & click join this group. Regards, Kuldeep Singh Info Edge India Limited (naukri.com) Phone.: +91-120-4763789, Extn.: 789 naukrikuld...@gmail.com || www.naukri.com *Please* *Consider the environment. Please don't print this e-mail unless y

$$Excel-Macros$$ Join this Group

Dear Experts, One of my friend wanna join this Group but I donna how to add him. Thanks Manjunath PLEASE CONSIDER THE ENVIRONMENT BEFORE PRINTING THIS E-MAIL For Aon's standard conditions associated with this e-mail please visit http://www.aon.com/uk/en/emai

Re: $$Excel-Macros$$ Dynamic calendar quiz : There is a prize for the winner.

Submitted :) On Mon, Nov 26, 2012 at 10:49 PM, Ayush Jain wrote: > Thanks Vinay > > Dear Group, only 6 days left for the quiz, give it a try and you will > learn something new > > Looking forward to your active participation > > Thanks > > Best regards > Ayush Jain > Group manager > > On Nov 26