Re: $$Excel-Macros$$ for due date

2013-09-26 Thread Aamir Shahzad
review the attached file for simple approach On Wed, Sep 25, 2013 at 4:15 PM, Ravi Kumar excellearn2...@gmail.comwrote: Hi, ** ** Another way… See the attached file. ** ** ** ** =DATE(YEAR(D5),MONTH(D5),DAY(D5)+15) ** ** ** ** * * *Warm Regards,* *Ravi Kumar.*

$$Excel-Macros$$ Small doubt in customize ribbon of user define function.

2013-09-26 Thread अनिल नारायण गवली
Dear Friends, I had made a macro, then created a new customized ribbon and assigned it with this macro. Problem is whenever i click on the ribbon to run the task then the original file where the macro is created is opening simulteneously. My idea is it should not open the file and only run the

Re: $$Excel-Macros$$ Small doubt in customize ribbon of user define function.

2013-09-26 Thread Dhartikumar Sahu
Write macro in addin file. On 26 Sep 2013 12:29, अनिल नारायण गवली gawlianil8...@gmail.com wrote: Dear Friends, I had made a macro, then created a new customized ribbon and assigned it with this macro. Problem is whenever i click on the ribbon to run the task then the original file where the

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

2013-09-26 Thread Trabelsi Hichem
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 doesnt appear correctly : this is the code i'm using : . . . FileName = C:\Submission

Re: $$Excel-Macros$$ Small doubt in customize ribbon of user define function.

2013-09-26 Thread अनिल नारायण गवली
Dear Friends, Sorry for distrubing you . The solution has been resloved now. Warm Regards, Gawli Anil Thanks Regards, Gawli Anil Narayan Software Developer, Abacus Software Services Pvt Ltd On Thu, Sep 26, 2013 at 12:29 PM, अनिल नारायण गवली gawlianil8...@gmail.com wrote: Dear Friends, I

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

2013-09-26 Thread Ravi Kumar
K try this one. Sub Sendmail1() ESubject = This is a test email SendTo = raviku...@gmail.com CCTo = Ebody = Testing VBA's ability to send an email. NewFileName = C:\Users\Admin\Desktop\t\test.jpg 'change according to your image Application.DisplayAlerts = False Set App =

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

2013-09-26 Thread Trabelsi Hichem
Hello Again, Thank you Ravi for your quick answer , but the instruction here .Body = Ebody will show in the body the string Testing VBA's ability to send an email., i want the attached image to be displayed normally in the body that's the problem, it worked before on Office 2003 but not

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

2013-09-26 Thread Ravi Kumar
Ok, I’ll try. Warm Regards, Ravi Kumar. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Trabelsi Hichem Sent: Thursday, September 26, 2013 12:52 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Re: Outlook 2010 : VBA Macro for

Re: $$Excel-Macros$$ Facing 'run-time error -2147217871 (80040e31) Automation error' in excel VBA

2013-09-26 Thread Junaid
Hi Rajan, I get this error, whenever I run the Macro. And below are the two connection strings I tried, but getting same error for both. strConnectionString = Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=True;Initial Catalog={abcd};Data Source={abcd};Use Procedure for

Re: $$Excel-Macros$$ Facing 'run-time error -2147217871 (80040e31) Automation error' in excel VBA

2013-09-26 Thread Junaid
Hi Anil, May I know where can I find logs for excel errors? Thanks On Thursday, 26 September 2013 11:25:29 UTC+5:30, अनिल नारायण गवली wrote: Dear Junaid, Kindly attach the error file . Warm Regards, Gawli Anil Thanks Regards, Gawli Anil Narayan Software Developer, Abacus

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

2013-09-26 Thread Trabelsi Hichem
I already found the solution, i shouldnt use the cid method, but i had to put the entire path of the image Thank you so much anyway :) -- 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$$ Array - Unique list

2013-09-26 Thread Chandra Shekar
Hello, Thank you gor the solution for this problem. Regards, Chandra On Wed, Sep 25, 2013 at 9:16 PM, rajan verma rajanverma1...@gmail.comwrote: Visit here http://excelpoweruser.wordpress.com/2011/08/09/get-unique-list-another-method/ For more method to get unique see this

$$Excel-Macros$$ paste special particular formula

2013-09-26 Thread Mukesh Kumar
Hi experts, I need a macro code to paste special a particular formula across many sheets. Every sheet contains different types of formulas, but i have to paste special a particular /specific formula. Please help me out. Regards, Mukesh Kumar -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in

Re: $$Excel-Macros$$ paste special particular formula

2013-09-26 Thread rajan verma
HI Mukesh i have seen this query many time on this group and another forums, please try this macro Sub PasteFormula() Dim rngRange As Range Dim VarArr Dim strFormula As String Dim varEle Dim lngR As Long Dim lngC As Long Dim lngCount As Long Set rngRange =

Re: $$Excel-Macros$$ paste special particular formula

2013-09-26 Thread Mukesh Kumar
Thanks a lot Sir for the help. On Thu, Sep 26, 2013 at 3:39 PM, rajan verma rajanverma1...@gmail.comwrote: HI Mukesh i have seen this query many time on this group and another forums, please try this macro Sub PasteFormula() Dim rngRange As Range Dim VarArr Dim strFormula

Re: $$Excel-Macros$$ paste special particular formula

2013-09-26 Thread Mukesh Kumar
Rajan ji , this macro code is limited to one sheet only. I want the macro that works upon all sheets at once. Regards, Mukesh Kumar On Thu, Sep 26, 2013 at 3:39 PM, rajan verma rajanverma1...@gmail.comwrote: HI Mukesh i have seen this query many time on this group and another forums, please

Re: $$Excel-Macros$$ paste special particular formula

2013-09-26 Thread rajan verma
Try this one Sub PasteFormula() Dim rngRange As Range Dim VarArr Dim strFormula As String Dim varEle Dim lngR As Long Dim lngC As Long Dim lngCount As Long Dim wksSheet As Worksheet strFormula = InputBox(Enter formula name to replace with values) lngCount

Re: $$Excel-Macros$$ paste special particular formula

2013-09-26 Thread rajan verma
use this one. Sub PasteFormula() Dim rngRange As Range Dim VarArr Dim strFormula As String Dim varEle Dim lngR As Long Dim lngC As Long Dim lngCount As Long Dim wksSheet As Worksheet strFormula = InputBox(Enter formula name to replace with values)

$$Excel-Macros$$ Index match help

2013-09-26 Thread Jeremy Lawson
Hi everybody. I am dealing with a rather complex equation, and could use some help. Most of the cells in the attached spreadsheet are blank, because the data are confidential. The relevant columns are highlighted. Basically, I am trying to use index match to find geographic salary

$$Excel-Macros$$ Extract last and first from columns.

2013-09-26 Thread Rajan sharma
Dear experts, I want to extract only first and last values or string from Columns, Please guide. Please find the attachment, i have provide sample. With warm regards, Rajan Sharma -- 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

Re: $$Excel-Macros$$ Extract last and first from columns.

2013-09-26 Thread Rajan sharma
Any body please suggest formulas or macros. please if it is possible.. Thanks With warm regards, Rajan Sharma On Fri, Sep 27, 2013 at 9:07 AM, Rajan sharma rajansharma9...@gmail.comwrote: Dear experts, I want to extract only first and last values or string from Columns, Please guide.

Re: $$Excel-Macros$$ Extract last and first from columns.

2013-09-26 Thread Aamir Shahzad
can you further brief? On Fri, Sep 27, 2013 at 9:49 AM, Rajan sharma rajansharma9...@gmail.comwrote: Any body please suggest formulas or macros. please if it is possible.. Thanks With warm regards, Rajan Sharma On Fri, Sep 27, 2013 at 9:07 AM, Rajan sharma

Re: $$Excel-Macros$$ Extract last and first from columns.

2013-09-26 Thread Rajan sharma
Thanks Amir sir, I have elaborated my query further in excel file, please find the attachment. With warm regards, Rajan Sharma On Fri, Sep 27, 2013 at 10:22 AM, Aamir Shahzad aamirshahza...@gmail.comwrote: can you further brief? On Fri, Sep 27, 2013 at 9:49 AM, Rajan sharma