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.*
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
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
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
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
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 =
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
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
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
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
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 @
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
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
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 =
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
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
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
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)
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
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
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.
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
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
23 matches
Mail list logo