good:thanks its of great help
On Sun, Jun 16, 2013 at 7:37 AM, De Premor wrote:
> For do that, you need to know the unique value on each computer to
> determine that the file was used on another computer.
> Something that will unique on every computer is Hardisk SN
>
> Private Sub Workbook_Open
Thanks
it is working.
Regards
On Sun, Jun 16, 2013 at 8:45 AM, xlstime wrote:
> Hi Dheeraj,
>
> Please find attach solution
>
> .
>
> Enjoy
> Team XLS
>
>
>
> On Sun, Jun 16, 2013 at 10:03 AM, Dheeraj Bankoti wrote:
>
>> Dear Ahmed,
>> Thanks for your reply. avergeifs d
Hi Deepak,
Please elaborate your requirement little more.
.
Enjoy
Team XLS
On Sun, Jun 16, 2013 at 10:03 AM, Dheeraj Bankoti wrote:
> Dear Ahmed,
> Thanks for your reply. avergeifs does not meet as per my requirement. It
> is working for complete column but I am looki
Hi,
You may refer:
http://www.vbaexpress.com/kb/getarticle.php?kb_id=475
http://www.vbaexpress.com/kb/getarticle.php?kb_id=540
File with example is there for better understanding..
Best Luck
On Sun, Jun 16, 2013 at 12:03 AM, sunil lobo wrote:
> hi all
> can anybody suggest a vb code or a m
For do that, you need to know the unique value on each computer to
determine that the file was used on another computer.
Something that will unique on every computer is Hardisk SN
Private Sub Workbook_Open()
Dim MySN, CurrentSN As String
MySN = "1409978829" 'Your Current Hardisk Serial N
I want to unsubscribe it.
From: Mithlesh Sharma
To: excel-macros@googlegroups.com
Sent: Saturday, 15 June 2013 8:18 PM
Subject: Re: $$Excel-Macros$$ List File Names from Folder in Excel
PFA excel file.
On Sat, Jun 15, 2013 at 5:39 PM, Vijayendra Rao
hi all
can anybody suggest a vb code or a macro to a excel file the moment it is
opened it can check on the usage of the file or it can stop from further
use until it is being given permission by the creator of the file
basically it should not be copied and if copied from one computer to the
other
PFA
http://www.xl-central.com/list-files-dir.html
http://www.excelvbamacros.com/p/index_1.html
Thanks
On Sat, Jun 15, 2013 at 5:39 PM, Vijayendra Rao wrote:
> Dear All,
>
> Is there any macros to create list names with subfolder and propertis from
> any folder. Currently I am using ASAP-Utili
Respected Prabhakar,
You can find information from the following links,
http://www.microsoft.com/learning/en/us/mos-certification.aspx#fbid=x8BGjYz2g2o
http://www.onlc.com/excel-certification-mos.html
http://www.excelprodigy.in/microsoft-certification.html#.UbxVsT4isRA
http://www.ehow.com/how_6240
in vba function split function is working is magic of instr:
Instr checks each word in sentence, if it contains @ then it is picked up &
thrown as result..
its using right logic with right function to reach destination in fastest
way..
HTH
On Sat, Jun 15, 2013 at 3:21 PM, ravinder negi wrote:
now i Understood, nice one and thanks...by the way I got formula also, put
value in cell a1 and paste formula in b2
=TRIM(MID(SUBSTITUTE(" "&A1," ",REPT(" ",125)),SEARCH("@",SUBSTITUTE(" "&A1,"
",REPT(" ",125)))-100,125))
--- On Sat, 6/15/13, De Premor wrote:
From: De Premor
Subject: Re: $$E
Function ExtractEmail(Sentence As String) As String
Dim Word
For Each Word In Split(Sentence, " ")
If InStr(1, Word, "@") > 0 Then ExtractEmail = Word
Next
End Function
For example: in case we have a sentence like "*please send mail to
some...@example.com or futher info*"
the
I want this in excel formula..this one also very nice can you explain how split
is working.
--- On Sat, 6/15/13, De Premor wrote:
From: De Premor
Subject: Re: $$Excel-Macros$$ Cell Merge - Reg
To: excel-macros@googlegroups.com
Date: Saturday, June 15, 2013, 2:13 PM
F
Try to use Average ifs if you are using Excel 2007 you shall get it.
Thanks,
Ahmed Bawazir
On Sat, Jun 15, 2013 at 1:34 AM, Dheeraj Bankoti wrote:
> Hi Experts,
> PFA a sample file, in which I need average quantity.
>
> Appreciate any inputs.
>
> Regards
>
> --
> Are you =EXP(E:RT) or =NOT(EX
Function ExtractEmail(Sentence As String) As String
Dim Word
For Each Word In Split(Sentence, " ")
If InStr(1, Word, "@") > 0 Then ExtractEmail = Word
Next
End Function
Pada 15/06/2013 15:03, ravinder negi menulis:
Hi all,
I have a query , I have made a formula for this bu
Dear All Experts
Here I required sum formula but as per time means sum near cell value after
every 5 minute.I attached sheet with all detailed Pls check it.
Regards
Amar
--
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
Hi all,
I have a query , I have made a formula for this but very long so I would like
some small formula to get email id only, pls help thanks in advance
abcd
billga...@microsoft.com xyz
12 xyz john_hay...@microsoft.com 34a bcd
billga...@yahoo.com 1234 abcd
abcd 1234 abc
Dear Rajeev
Please find attached message, i've writen dirty UDF for concatenate a
word in range on that file
please note that my UDF writen without filtering duplicate value on
defined range
Thanks,
[dp]
On 15/06/2013 13:27, Rajeev Kumar wrote:
Dear Experts,
Please find attached file and as
18 matches
Mail list logo
