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!http://www3.in.com/sso/commonregister.php?ref=INutm_source=inviteutm_medium=outgoing


-- 
-- 
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




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

2012-06-21 Thread 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




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 santoshkumar.subu...@gmail.com:
 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




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 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 excelkris...@in.com 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!http://www3.in.com/sso/commonregister.php?ref=INutm_source=inviteutm_medium=outgoing

 --
 -- 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 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 mangesh.da...@gmail.comwrote:

 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 excelkris...@in.com 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!http://www3.in.com/sso/commonregister.php?ref=INutm_source=inviteutm_medium=outgoing

 --
 -- 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 Maries
Thank you Krishna. Its very useful.

On Thu, Jun 21, 2012 at 7:54 PM, Kuldeep Singh naukrikuld...@gmail.comwrote:


 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 mangesh.da...@gmail.comwrote:

 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 excelkris...@in.comwrote:

 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!http://www3.in.com/sso/commonregister.php?ref=INutm_source=inviteutm_medium=outgoing

 --
 -- 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




-- 
*
*
*  MARIES*
Excel Inspiration http://xcel-inspiration.blogspot.com/

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

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!http://www3.in.com/sso/commonregister.php?ref=INutm_source=inviteutm_medium=outgoing
--
-- 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