$$Excel-Macros$$ Re: Outlook 2010 : VBA Macro for sending image in HTML Body doesn't display correctly

2013-09-30 Thread Trabelsi Hichem
Any news since ?? Le jeudi 26 septembre 2013 08:03:18 UTC+1, Trabelsi Hichem a écrit : Hello, I Use the following code to send emails automatically with embedded image in the HTML body, this worked with Office 2003, but when i upgrated to Office 2010 it doesnt work anymore, the image

Re: $$Excel-Macros$$ Reg : Count of Color filled cells - VBA Code required

2013-09-30 Thread Kartik Dale
Hi Ravinder, Thanks for the code, It's working fine. Regards, Kartik On Wed, Sep 25, 2013 at 3:28 PM, Ravinder ravinderexcelgr...@gmail.comwrote: Pfa….select range of colored cell when it ask. ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On

Re: $$Excel-Macros$$ Auto run multiple macros with data change

2013-09-30 Thread Anoop K Sharma
Hi, What code you have written behind Rate_KaPs_11. If possible please share your file. On Sun, Sep 29, 2013 at 1:28 PM, Warwick Trueman wtr...@gmail.com wrote: Hi all, my first post - I started teaching myself VBA two days ago, with predictable results! I want to run different macros

$$Excel-Macros$$ Macro to Import Word Tables to Excel from a folder

2013-09-30 Thread Nasir Khan
Hello All, I have got lot of MS Word files in a folder eg. C:\Test\many folders here I wish to copy and paste the Tables from all the word documents in the above mentioned folder to excel. I found Macro1 (see below) which copy and paste the Table in Excel. My requirement is to get the tables

RE: $$Excel-Macros$$ Function for coloring particular text

2013-09-30 Thread Ravinder
For Each cell In Selection With cell.Characters(Start:=3, Length:=1).Font .Color = vbRed End With Next From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Prafull Jadhav Sent: Sunday, September 29, 2013 10:00 PM To: excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Function for coloring particular text

2013-09-30 Thread Prafull Jadhav
Dear Ravinder Sir, I want to know can we create function for the same. *Regards, Prafull Jadhav 9920553518* On Mon, Sep 30, 2013 at 12:53 PM, Ravinder ravinderexcelgr...@gmail.comwrote: For Each cell In Selection With cell.Characters(Start:=3, Length:=1).Font .Color

$$Excel-Macros$$ Difference between time

2013-09-30 Thread Waseem Saifi
Dear Experts, I want to know total working time basis on in time and out time. please help me. please see attached file. Regards, Waseem Saifi -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @

$$Excel-Macros$$ Training Sylabus

2013-09-30 Thread Sundarvelan N
Dear Friends, Please share any training material with sylabus (Basic, Intermediate Advanced) to train new students. Thanks N.Sundarvelan 9600160150 -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @

RE: $$Excel-Macros$$ Difference between time

2013-09-30 Thread Ravinder
=TODAY()+B2-A2 From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Waseem Saifi Sent: Monday, September 30, 2013 3:29 PM To: excel-macros Subject: $$Excel-Macros$$ Difference between time Dear Experts, I want to know total working time basis on in time

Re: $$Excel-Macros$$ Difference between time

2013-09-30 Thread Aamir Shahzad
Try This =IF(A5B5,TEXT(A5-B5,[h]:mm:ss),TEXT(B5-A5,[h]:mm:ss)) On Mon, Sep 30, 2013 at 3:43 PM, Ravinder ravinderexcelgr...@gmail.comwrote: =TODAY()+B2-A2 ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Waseem Saifi *Sent:* Monday,

Re: $$Excel-Macros$$ Difference between time

2013-09-30 Thread Waseem Saifi
Thank you so much Ravinder Aamir. Regards, Waseem Saifi On Mon, Sep 30, 2013 at 4:18 PM, Aamir Shahzad aamirshahza...@gmail.comwrote: Try This =IF(A5B5,TEXT(A5-B5,[h]:mm:ss),TEXT(B5-A5,[h]:mm:ss)) On Mon, Sep 30, 2013 at 3:43 PM, Ravinder ravinderexcelgr...@gmail.comwrote:

$$Excel-Macros$$ Helpd needed

2013-09-30 Thread Ravinder Kumar
Hi, Please suggest a formula as per the below mention query. Weight Weight Weight PINCODE 0.5 1 1.5 744101 20 30 40 744102 10 15 20 Condition 1: Pincode wise Condition 2: Weight Thanks in advance. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s

Re: $$Excel-Macros$$ Helpd needed

2013-09-30 Thread ashish koul
can u share the excel file On Mon, Sep 30, 2013 at 7:00 PM, Ravinder Kumar ravinderbhardwa...@gmail.com wrote: Hi, Please suggest a formula as per the below mention query. Weight Weight Weight PINCODE 0.5 1 1.5 744101 20 30 40 744102 10 15 20 Condition 1: Pincode wise

Re: $$Excel-Macros$$ Helpd needed

2013-09-30 Thread Ravinder Kumar
Hi Ashish, Please find the attached file On Mon, Sep 30, 2013 at 7:01 PM, ashish koul koul.ash...@gmail.com wrote: can u share the excel file On Mon, Sep 30, 2013 at 7:00 PM, Ravinder Kumar ravinderbhardwa...@gmail.com wrote: Hi, Please suggest a formula as per the below mention

Re: $$Excel-Macros$$ Helpd needed

2013-09-30 Thread ashish koul
wht do u want to calculate On Mon, Sep 30, 2013 at 7:03 PM, Ravinder Kumar ravinderbhardwa...@gmail.com wrote: Hi Ashish, Please find the attached file On Mon, Sep 30, 2013 at 7:01 PM, ashish koul koul.ash...@gmail.comwrote: can u share the excel file On Mon, Sep 30, 2013 at 7:00

Re: $$Excel-Macros$$ Helpd needed

2013-09-30 Thread Ravinder Kumar
Hi Ashish, In a file we have Pin Code and weight, it will be check in a Rate Mater where the Rates are mention according to the Pincode wise. So when we go the Pin code and Weight then it automatically calculate. On Mon, Sep 30, 2013 at 7:05 PM, ashish koul koul.ash...@gmail.com wrote: wht

Re: $$Excel-Macros$$ Helpd needed

2013-09-30 Thread Anoop K Sharma
Hi Ravi, Please check attached one.. just change weightage or your values against pin code to get answer On Mon, Sep 30, 2013 at 7:10 PM, Ravinder Kumar ravinderbhardwa...@gmail.com wrote: Hi Ashish, In a file we have Pin Code and weight, it will be check in a Rate Mater where the Rates

Re: $$Excel-Macros$$ Calculating Euclidean distance in 2 dimension 3 dimension

2013-09-30 Thread Nise Buch
Can you unsubscribe me from this group, please? Tks. 2013/9/23 Debasish Sahu debasis...@gmail.com ​​Can somebody help me calculating euclidean distance for the attached sample file. Column 2, 3 4 contains X, Y Z information of samples for which the euclidean distance is required to be