Friends,
I have an excel spreadsheet with dates updated on it, all I need is that
the system should automatically send an Email to the specified email
address automatically by picking up that particular date.
Ex:
Date:Subject To
29/06/2012 Renew
Hi group,
Because of CTRl+D just fill down the data iam facing this problem, when i
want to use Ctrl+F unfortunatley it was accidently clicking Ctrl+D iam not
observing it later it was effecting to the data.
So i what i need is i want to *disable Ctrl+D with a passward* and same
time i want
Hi Mangesh,
Try using from Insert Menu -- Object -- choose Create from file and locate
your sheet path that is available in your respective file then an Icon is
displayed so being in a sheet when you click on that Icon you will get
another sheet.
Revert if you failed to understand the above. I
Dear members,
Please help me solve the above problem using macro or array formulae.
Problem - data seperated by hypen - and comma , to be written in
rows existing below (should not insert rows but place data in already
existing rows )
eg 1
X6-1,4,5,6,9,X7-23,56,67,X30 in cell C34
ANSWER
Dear Hemanath,
Please try it..
Sub maildata()
Dim olApp As Outlook.Application
Dim olMail As MailItem
Dim i As Integer, j As Integer
Dim sh As Worksheet
On Error Resume Next
Application.ScreenUpdating = False
Set olApp = New Outlook.Application
Set olMail = olApp.CreateItem(olMailItem)
Set sh =
Dear Hemnath,
before run the macro pls check on Ms outlook liberary
On Thu, Jun 28, 2012 at 4:05 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:
Dear Hemanath,
Please try it..
Sub maildata()
Dim olApp As Outlook.Application
Dim olMail As MailItem
Dim i As Integer, j As Integer
Dim
The macro below does exactly what is need but it doesn't prefix the letters
before the hypen.
eg 1
X6-1,4,5,6,9,X7-23,56,67,X30 in cell C34
ANSWER by using below macro -
X6-1 in cell c34
4 in cell c35
5 in cell C36
6 in cell C37
9 in cell C38 I want X6- also as a prefix
23
Hi Vijay,
Hope it helps you
Sub SeperateData()
Dim varVal As Variant
Dim lngLoop As Long
Dim rngRangeAs Range
Dim strIni As String
Dim strFinalAs String
Set rngRange = ActiveSheet.Range(A1)
varVal =
I have posted a request today itself,Should i fill the SURVEY FORM or
should i wait for a few days and fill the form when i get a response ?
Regards
Vijay
On Saturday, 9 June 2012 00:23:15 UTC+5:30, Ayush Jain wrote:
Dear members,
I have received very few responses on feedback
Thanks Noorain, Let me check this out.
On Thu, Jun 28, 2012 at 4:08 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:
Dear Hemnath,
before run the macro pls check on Ms outlook liberary
On Thu, Jun 28, 2012 at 4:05 PM, NOORAIN ANSARI
noorain.ans...@gmail.comwrote:
Dear Hemanath,
Thanks Lalit
On Thu, Jun 28, 2012 at 3:51 PM, Lalit_Mohan mohan.pande...@gmail.comwrote:
Hi Hemanath
Hope it helps you
'First add Tool - Refrence - Microsoft Outlook 12.0 object library
Sub ExportEmail()
Dim olApp As Object
Dim olMail
I still waiting for answers, Please advice
I tried to made it with myself, It look like better but still have problem
see my sheet, Please help
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of Attapan
Sent: Wednesday, June 27, 2012 9:46 PM
To:
Hi Experts
still waiting for solution
Divaker
On Tue, Jun 26, 2012 at 8:25 PM, Divaker Pandey divake...@gmail.com wrote:
but it will lock modification in list through vba.
Divker
On Tue, Jun 26, 2012 at 8:23 PM, NOORAIN ANSARI
noorain.ans...@gmail.comwrote:
Hi Divaker,
I have
Download from here
http://www.2shared.com/complete/CMFN-eEp/Building_Accounting_Systems_Us.html
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Kashan Abbas
Sent: 28 June 2012 1:32
To:
Dear Jitu,
As per Forum rule, Job related mail has been banned.
Brother take care in future.
On Thu, Jun 28, 2012 at 4:17 PM, Jitendra singh jeete2...@gmail.com wrote:
-- Forwarded message --
From: RJT Compuquest so...@rjtcindia.com
Date: Thu, Jun 28, 2012 at 1:26 PM
HI,
Hope this will meet your expectation
Sub SeperateData()
Dim varVal As Variant
Dim lngLoop As Long
Dim rngRangeAs Range
Dim strIni As String
Dim strFinalAs String
Dim strTemp As String
Dim lngVal
Hi Friends,
Thanks All for your valuable solution.
But, I need excel sheet when we click on its header so that I could
able to modify data.
Please Help !!!
On 6/28/12, Rajan_Verma rajanverma1...@gmail.com wrote:
Use this One ..
Problem is not identified but when I click on Twice on
Hi Noorain,
I think job related to excel vba mail should not be banned.
1. it will help to user to know what is in current demand in excel related
job.
2. it will encourage to learn and solve more excels quiz.
3. in last each enhanced skill is used to get better job options.
Regards.
Divaker
Hi Ahmed,
Thanks but it is not solution to my problem.
On 6/28/12, Ahmed Honest ahmedhon...@gmail.com wrote:
Hi Mangesh,
Try using from Insert Menu -- Object -- choose Create from file and locate
your sheet path that is available in your respective file then an Icon is
displayed so
That’s not possible
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of Mangesh Vimay
Sent: 28 June 2012 8:49
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Re: Need
Hi,
I have modified Rajan's code
A closer way to see the data as sheet on cell's double click
Please find the attached.
Regards,
Lalit Mohan
www.excelfox.com/forum
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of Mangesh Vimay
Totally agreed.
Warm Regards
Ankur Aggarwal
91-8010614628
Analyst
Mckinsey Knowledge Center
Mckinsey Co.
From: Divaker Pandey divake...@gmail.com
To: excel-macros@googlegroups.com
Sent: Thursday, 28 June 2012 8:44 PM
Subject: Re: $$Excel-Macros$$ Fwd: MIS
Nice Pandey ;)
On Fri, Jun 29, 2012 at 12:22 AM, vijay yadav
vijay.ganesh.ya...@gmail.comwrote:
Thanks Lalit_Mohan
,You are a genius,great work done.
This gives me 95 % correct results but due to 2 bug or errors I have to
check everything and correct it.
The bug or errors are
1)THE X
Dear Divakar,
Please see earlier discussion on this topic.
Date: Sat, 16 Jun 2012 08:14:00 -0700
From: jainayus...@gmail.com
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Re: MIS executive
Hi Yogananda,
Please note that Job posting is allowed in this forum. Please do not post
Hi gm experts,
is anybody solve my problem reg. disable ctrl+d option.
Iam waiting for solution for the problem.
On Thu, Jun 28, 2012 at 2:34 PM, Muralidhar E emuralidha...@gmail.comwrote:
Hi group,
Because of CTRl+D just fill down the data iam facing this problem, when i
want to use
Thanks Asa and belatedly Noorain. The format function worked and as it
happens the other method was returning the wrong day for all those who
might use it.
The .value2 does not seem to be necessary but I left it anyway.
On Wednesday, June 27, 2012 10:09:16 PM UTC-7, tangledweb wrote:
Asa!
26 matches
Mail list logo