its not working,
is it possible i can send you the data sheet
On Oct 12, 7:10 pm, Paul Schreiner wrote:
> ok... I'm not sure what happened to my last email,
> but I'll try again...
>
> I threw this together.
>
> It saves the email addresses into a "Dictionary Object".
> (I like using them becau
Hi Michael,
Actually, if the name of sheet 2 is matching in the list in Sheet 1, then I
am saying as "Found". Further to this, I have fetched those names which are
matched considering full name and only the first name. Please look at the
attached file for further understanding.
Best Regards,
--
Hi Rajeev,
Attached solution is customized to meet your requirements as well.
Best Regards,
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062
On 10/10/09, Rajeev Nandan wrote:
>
> Hi Mr.Dilip,
> I want to writ
Hi Zaheer,
Solution is enhanced to accommodate the requirement and attached herewith.
Thanks.
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062
On 10/10/09, ~ Z A H E E R ~ wrote:
>
> Hi Dilip,
>
> Thanx for yo
If you are REALLY concerned about the users of your workbook using
specific commands you could also turn them off by using the OnKey
method in the Workbook_Open event handler. Here's the code on how to
do that for "CTRL+X":
Private Sub Workbook_Open()
Application.OnKey "^{x}", ""
End Sub
Che
Hi,
I have prepared a macro to get the report done using dao object. what
the macro is doing, it is getting data from the same workbook using
DAO object from different sheet using SQL. Every thing goes well but
the problem comes when I closed the final report in excel application,
the VB project
As long as you DON'T try to do any calculations with cell B5 (for the
reason explained by Paul) you would use the following formula in cell
B5:
=IF(B1="USD K",CONCATENATE("USD ",TEXT(B11,"#,###")),CONCATENATE("INR
",TEXT(B10,"#.#")))
If you do need to do calculations with the value in cell B5 I
If you don't have Excel2007 it gets a bit more complicated. Here is
one way to accomplish what you would like to do (for the sake of
simplicity I am assuming that your dates are in column A, and that
column B can be used as helper column and that you have a header in
the first row (cell A1)):
Ste
I have an Excel based application that references Microsoft ActiveX
Data Objects 2.8 Lib. I am about to push this application out to
multiple users within our company, but some of them only have
Microsoft ActiveX Data Objects 2.5 Lib. Will my application run
properly if a user has an older versi
hello,
hope you can help,have a worksheet with 2 sheets,class,table.in
m1:r1 subject headings and m2:m8 will be pupils names and test scores
for that class subject, same for rest with different names for
different subjects.anyhow i will have a2:f2 poulated randomly from the
lists in m2:r8 ei(a2 wi
I don't think I can do it using "standard" Excel functions.
but I threw together this function:
Option Explicit
Public Function Find_Str(Search_Text, Data_Array As Range)
Dim Data, fflag
fflag = False
For Each Data In Data_Array
If (UCase(Data.Value) = UCase(Search_Text)) Then
Thanks & Regards,
Harmeet Singh
Sent via BlackBerry Wireless
-- Forwarded message --
From: Harmeet Singh
Date: Mon, Oct 12, 2009 at 7:28 PM
Subject: Re: $$Excel-Macros$$ Running Mecro automatically
To: Manish Pansari
Here u go
Thanks & Regards,
Harmeet Singh
Sent
If I correctly understand Nader's requirement he would like to
hyperlink each cell in one sheet to the corresponding cell in a second
sheet (not all cells to cell A1 of the second sheet). I am not aware
of a simple copy and paste route that would accomplish that, but can
offer the following macro
Hi All,
Can some body help me in cracking a PDF password.
I have down loaded a PDF file which is zipped and has a password. I have
also downloaded a password cracker also, but I am unable to unzip the file.
The password cracker can crack the password only in the PDF file.
Please Help Me
Rega
Hi,
I have a rectangular range of cells, each one with one word.
I have several rows with words and I would like to find if these words
match one of the words in the range, and if positive, in which cell of
the range.
How can I accomplish this ? (if only with functions the better)
Thanks/Brgds
you can use the software Elcomsoft Advanced PDF Password Recovery v4.00
from website
vikas gupta
On Wed, Sep 30, 2009 at 9:47 PM, Mog Obahor wrote:
>
> send it to me vivek I will help u crack it.
>
> On 9/30/09, vivek agrawal wrote:
> > Hi There..
> >
> > I have downloaded a pdf file which i
Following code was sent by someone in one of the group emails recently.
I want to send attachment to multiple people, one at a time, using excel lists
and path info.
please modify the below code for this.
regards
Haresh
Sub SendMail()
Dim objOut As Outlook.Application
Dim objMail As Outlook.
Hi Prashant
Please find the attached solution
Hemant Hegde
2009/10/11 Prashant Bhawar
>
> Plz help here i attached a problem file with required ans. plz help me
> --
> Warm Regard
>
> Prashant Bhawar
>
> ( CA Final )
>
> >
>
--
Hemant Hegde
--~--~-~--~~~---~--
ok... I'm not sure what happened to my last email,
but I'll try again...
I threw this together.
It saves the email addresses into a "Dictionary Object".
(I like using them because they are very fast)
It then determines the last entry in the Data sheet
and works it's way backwords, looking for th
yes, it's possible.
the question is: how do you identify
the beginning of the "customer record"?
What I would do is:
Read the email addresses from the second sheet
and store them (by customer ID) in a
"Dictionary Object".
then, set up a loop that starts at the LAST row
and works backward
(store
A database of customers includes complete information except the email
addresses. A new sheet "sheet 2 " is added with Email Addresses in one
column "b" with Unique Customer Code in Column "A".
Records for some customers use 2 rows and some use more rows.
Printing size restricts addition of c
*Below code will help*
*
*
*Sub waitt()*
*For i = 1 To 5 'will run 5 times*
*'ur code*
*Application.Wait Now + TimeValue("00:00:05") '''will wait for 5 seconds*
*Next*
*End Sub*
Thanks & Regards,
Harmeet Singh
Sent via BlackBerry Wireless
On Sun, Oct 11, 2009 at 2:29 PM, Manish
thanks tushar
On Sat, Oct 10, 2009 at 10:43 PM, tushar patki wrote:
> Hi Prabhakar,
>
> The transactions pertaining to capital gains are not so straight forward,
> say for eg whether the STT is paid on the same or what about the exemptions
> available etc. There may be many other angles attached
23 matches
Mail list logo
