Re: $$Excel-Macros$$ Formula for Username in a cell

2012-06-22 Thread prkhan56
Hello Krishna
I cannot open the file.
Can you please check your file?
Thanks 
Rashid Khan
On Thursday, June 21, 2012 6:57:23 PM UTC+4, Krishnaraddi wrote:

> Hi All
>
> Please find the attached PPT consists of few useful excel functions 
> explained. I have prepared this document for training purpose thought to 
> share with this group.
>
>
> 
>
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please 
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice 
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security 
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in 
> signatures are prohibited. 
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum 
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to 
> excel-macros+unsubscr...@googlegroups.com
>
>
>
>
> Dear *excel-macros !* Get Yourself a cool, short *@in.com* Email ID 
> now!
>

-- 
-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com




RE: $$Excel-Macros$$ Formula for Username in a cell

2012-06-21 Thread Amit Desai (MERU)
This is Grt work...

Do you have more ppts please share...

Also please share detailed notes with examples if you have...

Best Regards,
Amit

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On 
Behalf Of Krishnaraddi
Sent: 21 June 2012 20:27
To: excel-macros
Subject: $$Excel-Macros$$ Formula for Username in a cell


Hi All,

Please find the attached PPT consists of few useful excel functions explained. 
I have prepared this document for training purpose thought to share with this 
group.



FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5) Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited.

NOTE : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com


Dear excel-macros ! Get Yourself a cool, short @in.com Email ID 
now!
--
-- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, 
accurate thread titles. Poor thread titles, like Please Help, Urgent, Need 
Help, Formula Problem, Code Problem, and Need Advice will not get quick 
attention or may not be answered. 2) Don't post a question in the thread of 
another member. 3) Don't post questions regarding breaking or bypassing any 
security measure. 4) Acknowledge the responses you receive, good or bad. 5) 
Cross-promotion of, or links to, forums competitive to this forum in signatures 
are prohibited. NOTE : Don't ever post personal or confidential data in a 
workbook. Forum owners and members are not responsible for any loss. 
--
 To post to this group, send email to excel-macros@googlegroups.com To 
unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com


Disclaimer: This message and its attachments contain confidential information 
and may also contain legally privileged information. This message is intended 
solely for the named addressee. If you are not the addressee indicated in this 
message (or authorized to receive for addressee), you may not copy or deliver 
any part of this message or its attachments to anyone or use any part of this 
message or its attachments. Rather, you should permanently delete this message 
and its attachments (and all copies) from your system and kindly notify the 
sender by reply e-mail. Any content of this message and its attachments that 
does not relate to the official business of Meru Cab Company Pvt. Ltd. must be 
taken not to have been sent or endorsed by any of them. Email communications 
are not private and no warranty is made that e-mail communications are timely, 
secure or free from computer virus or other defect.

-- 
-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com




Re: $$Excel-Macros$$ Formula for Username in a cell

2012-06-21 Thread Maries
Thank you Krishna. Its very useful.

On Thu, Jun 21, 2012 at 7:54 PM, Kuldeep Singh wrote:

>
> Hi,
>
> Thank you so much
>
> Regards,
> Kuldeep Singh
> Phone.: +91-9716615535
> naukrikuld...@gmail.com || www.naukri.com
> *Please* *Consider the environment. Please don't print this e-mail unless
> you really need to.*
>
>
> On Thu, Jun 21, 2012 at 9:21 PM, Mangesh Vimay wrote:
>
>> So Nice and also I never seen such a nice tutorial on Excel, Good user
>> friendly, easy and simply superb
>> Thanks dear.
>>
>>
>> On Thu, Jun 21, 2012 at 8:27 PM, Krishnaraddi wrote:
>>
>>> Hi All,
>>>
>>> Please find the attached PPT consists of few useful excel functions
>>> explained. I have prepared this document for training purpose thought to
>>> share with this group.
>>>
>>>
>>> 
>>>
>>> FORUM RULES (986+ members already BANNED for violation)
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>> will not get quick attention or may not be answered.
>>>
>>> 2) Don't post a question in the thread of another member.
>>>
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>>
>>> 4) Acknowledge the responses you receive, good or bad.
>>>
>>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>>> signatures are prohibited.
>>>
>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>> Forum owners and members are not responsible for any loss.
>>>
>>>
>>> --
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>> To unsubscribe, send a blank email to
>>> excel-macros+unsubscr...@googlegroups.com
>>>
>>>
>>>
>>>
>>> Dear *excel-macros !* Get Yourself a cool, short *@in.com* Email ID 
>>> now!
>>>
>>> --
>>> -- FORUM RULES (986+ members already BANNED for violation) 1) Use
>>> concise, accurate thread titles. Poor thread titles, like Please Help,
>>> Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not
>>> get quick attention or may not be answered. 2) Don't post a question in the
>>> thread of another member. 3) Don't post questions regarding breaking or
>>> bypassing any security measure. 4) Acknowledge the responses you receive,
>>> good or bad. 5) Cross-promotion of, or links to, forums competitive to this
>>> forum in signatures are prohibited. NOTE : Don't ever post personal or
>>> confidential data in a workbook. Forum owners and members are not
>>> responsible for any loss.
>>> --
>>> To post to this group, send email to excel-macros@googlegroups.com To
>>> unsubscribe, send a blank email to
>>> excel-macros+unsubscr...@googlegroups.com
>>
>>
>>
>>
>> --
>> With regards,
>>
>> MaNgEsH
>>
>>  --
>> -- FORUM RULES (986+ members already BANNED for violation) 1) Use
>> concise, accurate thread titles. Poor thread titles, like Please Help,
>> Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not
>> get quick attention or may not be answered. 2) Don't post a question in the
>> thread of another member. 3) Don't post questions regarding breaking or
>> bypassing any security measure. 4) Acknowledge the responses you receive,
>> good or bad. 5) Cross-promotion of, or links to, forums competitive to this
>> forum in signatures are prohibited. NOTE : Don't ever post personal or
>> confidential data in a workbook. Forum owners and members are not
>> responsible for any loss.
>> --
>> To post to this group, send email to excel-macros@googlegroups.com To
>> unsubscribe, send a blank email to
>> excel-macros+unsubscr...@googlegroups.com
>>
>
>  --
> -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise,
> accurate thread titles. Poor thread titles, like Please Help, Urgent, Need
> Help, Formula Problem, Code Problem, and Need Advice will not get quick
> attention or may not be answered. 2) Don't post a question in the thread of
> another member. 3) Don't post questions regarding breaking or bypassing any
> security measure. 4) Acknowledge the responses you receive, good or bad. 5)
> Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited. NOTE : Don't ever post personal or confidential
> data in a workbook. Forum owners and members are not responsible for any
> loss.
> --
> To post to this group, send email to excel-macros@googlegroups.com To
> unsubscribe, se

Re: $$Excel-Macros$$ Formula for Username in a cell

2012-06-21 Thread Kuldeep Singh
Hi,

Thank you so much

Regards,
Kuldeep Singh
Phone.: +91-9716615535
naukrikuld...@gmail.com || www.naukri.com
*Please* *Consider the environment. Please don't print this e-mail unless
you really need to.*

On Thu, Jun 21, 2012 at 9:21 PM, Mangesh Vimay wrote:

> So Nice and also I never seen such a nice tutorial on Excel, Good user
> friendly, easy and simply superb
> Thanks dear.
>
>
> On Thu, Jun 21, 2012 at 8:27 PM, Krishnaraddi  wrote:
>
>> Hi All,
>>
>> Please find the attached PPT consists of few useful excel functions
>> explained. I have prepared this document for training purpose thought to
>> share with this group.
>>
>>
>> 
>>
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> To unsubscribe, send a blank email to
>> excel-macros+unsubscr...@googlegroups.com
>>
>>
>>
>>
>> Dear *excel-macros !* Get Yourself a cool, short *@in.com* Email ID 
>> now!
>>
>> --
>> -- FORUM RULES (986+ members already BANNED for violation) 1) Use
>> concise, accurate thread titles. Poor thread titles, like Please Help,
>> Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not
>> get quick attention or may not be answered. 2) Don't post a question in the
>> thread of another member. 3) Don't post questions regarding breaking or
>> bypassing any security measure. 4) Acknowledge the responses you receive,
>> good or bad. 5) Cross-promotion of, or links to, forums competitive to this
>> forum in signatures are prohibited. NOTE : Don't ever post personal or
>> confidential data in a workbook. Forum owners and members are not
>> responsible for any loss.
>> --
>> To post to this group, send email to excel-macros@googlegroups.com To
>> unsubscribe, send a blank email to
>> excel-macros+unsubscr...@googlegroups.com
>
>
>
>
> --
> With regards,
>
> MaNgEsH
>
>  --
> -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise,
> accurate thread titles. Poor thread titles, like Please Help, Urgent, Need
> Help, Formula Problem, Code Problem, and Need Advice will not get quick
> attention or may not be answered. 2) Don't post a question in the thread of
> another member. 3) Don't post questions regarding breaking or bypassing any
> security measure. 4) Acknowledge the responses you receive, good or bad. 5)
> Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited. NOTE : Don't ever post personal or confidential
> data in a workbook. Forum owners and members are not responsible for any
> loss.
> --
> To post to this group, send email to excel-macros@googlegroups.com To
> unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>

-- 
-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com




Re: $$Excel-Macros$$ Formula for Username in a cell

2012-06-21 Thread Mangesh Vimay
So Nice and also I never seen such a nice tutorial on Excel, Good user
friendly, easy and simply superb
Thanks dear.

On Thu, Jun 21, 2012 at 8:27 PM, Krishnaraddi  wrote:

> Hi All,
>
> Please find the attached PPT consists of few useful excel functions
> explained. I have prepared this document for training purpose thought to
> share with this group.
>
>
> 
>
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>
>
>
>
> Dear *excel-macros !* Get Yourself a cool, short *@in.com* Email ID 
> now!
>
> --
> -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise,
> accurate thread titles. Poor thread titles, like Please Help, Urgent, Need
> Help, Formula Problem, Code Problem, and Need Advice will not get quick
> attention or may not be answered. 2) Don't post a question in the thread of
> another member. 3) Don't post questions regarding breaking or bypassing any
> security measure. 4) Acknowledge the responses you receive, good or bad. 5)
> Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited. NOTE : Don't ever post personal or confidential
> data in a workbook. Forum owners and members are not responsible for any
> loss.
> --
> To post to this group, send email to excel-macros@googlegroups.com To
> unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com




-- 
With regards,

MaNgEsH

-- 
-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com




RE: $$Excel-Macros$$ Formula for Username in a cell

2012-06-21 Thread Rajan_Verma
Hi

I think there Is no function that will return user name ..
You have to use VBA as per my knowledge

Function Uname() as string
UName=Environ("UserName")
End Function



Regards
Rajan verma
+91 7838100659 [IM-Gtalk]

-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of santosh subudhi
Sent: 21 June 2012 8:33
To: excel-macros
Subject: $$Excel-Macros$$ Formula for Username in a cell

Hi Group,

Is there a formula to get the user name in a cell the way we get it in VBA
i.e application.username

My comp doesn't allow Macro hence I need a formula to do so.

--
Regards
Santosh
santoshkumar.subu...@gmail.com

--
--
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
not get quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security
measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.


--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to
excel-macros+unsubscr...@googlegroups.com


-- 
-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com




Re: $$Excel-Macros$$ Formula for Username in a cell

2012-06-21 Thread ChilExcel
please add in Module


Function User() As String

User = Application.UserName

End Function


Chilexcel

2012/6/21 santosh subudhi :
> Hi Group,
>
> Is there a formula to get the user name in a cell the way we get it in
> VBA i.e application.username
>
> My comp doesn't allow Macro hence I need a formula to do so.
>
> --
> Regards
> Santosh
> santoshkumar.subu...@gmail.com
>
> --
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
> Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not 
> get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5)  Cross-promotion of, or links to, forums competitive to this forum in 
> signatures are prohibited.
>
> NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
> owners and members are not responsible for any loss.
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to 
> excel-macros+unsubscr...@googlegroups.com
>
>



-- 
Visita ; http://sites.google.com/site/chilexcel/Home
Visita ; http://www.youtube.com/user/timextag41

-- 
-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com