Re: $$Excel-Macros$$ share Dashboard Examples/Templates

2012-06-19 Thread CoRe
Hello Noorain, 
 
That ain't a tutorial , but thanks for sharing

On Monday, June 18, 2012 8:47:45 PM UTC+3, NOORAIN ANSARI wrote:

 Dear Pankaj,

 Please find attached Dashboard Tutorials, 
 Hope it will help to you.


 -- 
 Thanks  regards,
 Noorain Ansari
 www.noorainansari.com 
 www.excelmacroworld.blogspot.com

 On Mon, Jun 18, 2012 at 11:01 PM, pankaj gmail account 
 pankaji...@gmail.com wrote:

 Dear All,
  
 Please share Dashboard Examples/Templates
  
 I already viewed Chandoo's Site so no reference to that site.

 -- 
 Pankaj Kumar

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

$$Excel-Macros$$ How to creat digital watch in excel

2012-06-19 Thread Suman
Hi,
every one..!
i'm trying to write a macro to create a digital watch in excel please guide
me..

Regards,
@Suman
Send on the move with Galexy y.

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

2012-06-19 Thread Seraj Alam
-- 
Thanks  Regards
Seraj Alam
*+91 989 130 1776*

-- 
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$$ Re: How to creat digital watch in excel

2012-06-19 Thread Rajan_Verma
Hi
 
In workbook code module Paste this :
 
 
Private Sub Workbook_BeforeClose(Cancel As Boolean)
StopIt
End Sub
 
Private Sub Workbook_Open()
   GetStart
End Sub
 
in Standart Module paste this:
 
 
Sub GetStart()
Range(A1).Value = Format(Now, HH:MM:SS)
Application.OnTime Now + TimeValue(00:00:01), GetStart
End Sub
Sub StopIt()
On Error Resume Next
Application.OnTime Now + TimeValue(00:00:01), GetStart, , False
End Sub
Save your file in xlsm format , close it and Reopen ..
 
HTH
 
Rajan.
 
 

On Tuesday, 19 June 2012 15:49:10 UTC+5:30, suman kumar wrote:

 Hi,
 every one..!
 i'm trying to write a macro to create a digital watch in excel please 
 guide me..

 Regards,
 @Suman
 Send on the move with Galexy y.


-- 
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$$ Re: share Dashboard Examples/Templates

2012-06-19 Thread Mangesh Vimay
Many many thanks for this




On Tue, Jun 19, 2012 at 6:39 PM, CoRe neculae.vale...@gmail.com wrote:

 Hello Pankaj,

 As far as i know chandoo has greate dashboard templates for free ,

 Attached you can find out a few chandoo dashboards , maybe they skipped
 your eyes.






 On Monday, June 18, 2012 8:31:48 PM UTC+3, panky wrote:

 Dear All,

 Please share Dashboard Examples/Templates

 I already viewed Chandoo's Site so no reference to that site.

 --
 Pankaj Kumar

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

$$Excel-Macros$$ Please help : Use of Criteria Rule1-2

2012-06-19 Thread Suyog
Hello Expert,

I've studied Attendance register made by Santosh. I have not understood how 
excel is using criteria2, criteria3 etc  Rule 1  2.
I've tried to find same in excel function list to read help but I've not 
found.

Please advice or share syntax. Please share good book for excel 2007 for 
study.

Thanks  regards,
Suyog

-- 
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$$ Please help : Use of Criteria Rule1-2

2012-06-19 Thread santosh subudhi
Hi Suyog,

I have used the name ranges in the sheet.

If function starts with logical reason, to view the name ranges press
CTRL+F3

So I have defined each logic a diffrent name like criteria 2 ,criteria3
like that

Hope I have cleared you doubt, if you still have any queries please feel
free to contact me.

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



--
Date: Tue, 19 Jun 2012 06:32:56 -0700
From: nashi...@gmail.com
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Please help : Use of Criteria  Rule1-2

Hello Expert,

I've studied Attendance register made by Santosh. I have not understood how
excel is using criteria2, criteria3 etc  Rule 1  2.
I've tried to find same in excel function list to read help but I've not
found.

Please advice or share syntax. Please share good book for excel 2007 for
study.

Thanks  regards,
Suyog

-- 
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$$ Re: share Dashboard Examples/Templates

2012-06-19 Thread Mangesh Vimay
Thanks Noorain for sharing such nice examples..!!!



On Tue, Jun 19, 2012 at 6:51 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:

 PFA


 On Tue, Jun 19, 2012 at 6:49 PM, Mangesh Vimay mangesh.da...@gmail.comwrote:

 Many many thanks for this




 On Tue, Jun 19, 2012 at 6:39 PM, CoRe neculae.vale...@gmail.com wrote:

 Hello Pankaj,

 As far as i know chandoo has greate dashboard templates for free ,

 Attached you can find out a few chandoo dashboards , maybe they skipped
 your eyes.






 On Monday, June 18, 2012 8:31:48 PM UTC+3, panky wrote:

 Dear All,

 Please share Dashboard Examples/Templates

 I already viewed Chandoo's Site so no reference to that site.

 --
 Pankaj Kumar

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




 --
 Thanks  regards,
 Noorain Ansari
 www.noorainansari.com
 www.excelmacroworld.blogspot.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




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

$$Excel-Macros$$ Need your help !!!

2012-06-19 Thread Mangesh Vimay
Hi Friends, In above example, if we input the name like ABC then it should
display it's apropriate values
in the table from the above list.
Please find the attached sheet.
How can we find the solution by using Vlookup() function? . Thanks


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

Example_Name.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet


Re: $$Excel-Macros$$ Need your help !!!

2012-06-19 Thread NOORAIN ANSARI
Dear Mangesh,

Please try it..

=VLOOKUP($H9,IF($A$2:$A$10=$H$7,$B$2:$E$10,0),MATCH(I$8,$B$1:$E$1,0),0)
with ctrl+Shift+enter

-- 
Thanks  regards,
Noorain Ansari
www.noorainansari.com
www.excelmacroworld.blogspot.com


On Tue, Jun 19, 2012 at 8:59 PM, Mangesh Vimay mangesh.da...@gmail.comwrote:

 Hi Friends, In above example, if we input the name like ABC then it should
 display it's apropriate values
 in the table from the above list.
 Please find the attached sheet.
 How can we find the solution by using Vlookup() function? . Thanks


 --
 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$$ Need your help !!!

2012-06-19 Thread NOORAIN ANSARI
see attached sheet

On Tue, Jun 19, 2012 at 9:06 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:

 Dear Mangesh,

 Please try it..

 =VLOOKUP($H9,IF($A$2:$A$10=$H$7,$B$2:$E$10,0),MATCH(I$8,$B$1:$E$1,0),0)
 with ctrl+Shift+enter

 --
 Thanks  regards,
 Noorain Ansari
 www.noorainansari.com
 www.excelmacroworld.blogspot.com


 On Tue, Jun 19, 2012 at 8:59 PM, Mangesh Vimay mangesh.da...@gmail.comwrote:

 Hi Friends, In above example, if we input the name like ABC then it
 should display it's apropriate values
 in the table from the above list.
 Please find the attached sheet.
 How can we find the solution by using Vlookup() function? . Thanks


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










-- 
Thanks  regards,
Noorain Ansari
www.noorainansari.com
www.excelmacroworld.blogspot.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

Example_Name(Solved).xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet


Re: $$Excel-Macros$$ Re: How to creat digital watch in excel

2012-06-19 Thread ChilExcel
Rajan ..

I created an add ins to add to the clock
its purpose is to determine the timecode breaks

 talk about its usefulness

example



   Stat  End time difference
21:49:23,66 21:49:28,61 00:00:04,95

Chilexcel

2012/6/19 Rajan_Verma rajanverma1...@gmail.com:
 Hi

 In workbook code module Paste this :


 Private Sub Workbook_BeforeClose(Cancel As Boolean)
     StopIt
 End Sub

 Private Sub Workbook_Open()
    GetStart
 End Sub

 in Standart Module paste this:


 Sub GetStart()
     Range(A1).Value = Format(Now, HH:MM:SS)
     Application.OnTime Now + TimeValue(00:00:01), GetStart
 End Sub
 Sub StopIt()
     On Error Resume Next
     Application.OnTime Now + TimeValue(00:00:01), GetStart, , False
 End Sub
 Save your file in xlsm format , close it and Reopen ..

 HTH

 Rajan.



 On Tuesday, 19 June 2012 15:49:10 UTC+5:30, suman kumar wrote:

 Hi,
 every one..!
 i'm trying to write a macro to create a digital watch in excel please
 guide me..

 Regards,
 @Suman
 Send on the move with Galexy y.

 --
 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$$ How to creat digital watch in excel

2012-06-19 Thread Suman
Tkanks a lot Noorain ji,will u please explain how its working?

Regards,
@Suman
Send on the move with Galexy y.
On Jun 19, 2012 3:49 PM, Suman ksuman1...@gmail.com wrote:

 Hi,
 every one..!
 i'm trying to write a macro to create a digital watch in excel please
 guide me..

 Regards,
 @Suman
 Send on the move with Galexy y.

 --
 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$$ Re: How to creat digital watch in excel

2012-06-19 Thread Rajan_Verma
nice


Regards
Rajan verma
+91 7838100659 [IM-Gtalk]

-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of ChilExcel
Sent: 19 June 2012 9:09
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Re: How to creat digital watch in excel

Rajan ..

I created an add ins to add to the clock its purpose is to determine the
timecode breaks

 talk about its usefulness

example



   Stat  End time difference
21:49:23,66 21:49:28,61 00:00:04,95

Chilexcel

2012/6/19 Rajan_Verma rajanverma1...@gmail.com:
 Hi

 In workbook code module Paste this :


 Private Sub Workbook_BeforeClose(Cancel As Boolean)
     StopIt
 End Sub

 Private Sub Workbook_Open()
    GetStart
 End Sub

 in Standart Module paste this:


 Sub GetStart()
     Range(A1).Value = Format(Now, HH:MM:SS)
     Application.OnTime Now + TimeValue(00:00:01), GetStart
 End Sub
 Sub StopIt()
     On Error Resume Next
     Application.OnTime Now + TimeValue(00:00:01), GetStart, , 
 False End Sub Save your file in xlsm format , close it and Reopen ..

 HTH

 Rajan.



 On Tuesday, 19 June 2012 15:49:10 UTC+5:30, suman kumar wrote:

 Hi,
 every one..!
 i'm trying to write a macro to create a digital watch in excel please 
 guide me..

 Regards,
 @Suman
 Send on the move with Galexy y.

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


-- 
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$$ Re: How to creat digital watch in excel

2012-06-19 Thread Suman
Thanks a lot rajan jee..!

-- 









*Suman Kumar*




On Tue, Jun 19, 2012 at 4:21 PM, Rajan_Verma rajanverma1...@gmail.comwrote:

 Hi

 In workbook code module Paste this :


 Private Sub Workbook_BeforeClose(Cancel As Boolean)
 StopIt
 End Sub

 Private Sub Workbook_Open()
GetStart
 End Sub

 in Standart Module paste this:


 Sub GetStart()
 Range(A1).Value = Format(Now, HH:MM:SS)
 Application.OnTime Now + TimeValue(00:00:01), GetStart
 End Sub
 Sub StopIt()
 On Error Resume Next
 Application.OnTime Now + TimeValue(00:00:01), GetStart, , False
 End Sub
 Save your file in xlsm format , close it and Reopen ..

 HTH

 Rajan.



 On Tuesday, 19 June 2012 15:49:10 UTC+5:30, suman kumar wrote:

 Hi,
 every one..!
 i'm trying to write a macro to create a digital watch in excel please
 guide me..

 Regards,
 @Suman
 Send on the move with Galexy y.

 --
 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.comA_html_m691da4f3.gif

Re: $$Excel-Macros$$ Re: How to creat digital watch in excel

2012-06-19 Thread ChilExcel
Rajan 

only commented the work I've done

1 .- move the cursor and enter hours
2 .- hours Clickleft button entry
3 .- add ins stopwatch to determine differences
4 .- formulated to test differences

Atte

Chilexcel




2012/6/19 Suman ksuman1...@gmail.com

 Thanks a lot rajan jee..!

 --









 *Suman Kumar*




  On Tue, Jun 19, 2012 at 4:21 PM, Rajan_Verma rajanverma1...@gmail.comwrote:

 Hi

 In workbook code module Paste this :


 Private Sub Workbook_BeforeClose(Cancel As Boolean)
 StopIt
 End Sub

 Private Sub Workbook_Open()
GetStart
 End Sub

 in Standart Module paste this:


 Sub GetStart()
 Range(A1).Value = Format(Now, HH:MM:SS)
 Application.OnTime Now + TimeValue(00:00:01), GetStart
 End Sub
 Sub StopIt()
 On Error Resume Next
 Application.OnTime Now + TimeValue(00:00:01), GetStart, , False
 End Sub
 Save your file in xlsm format , close it and Reopen ..

 HTH

 Rajan.



 On Tuesday, 19 June 2012 15:49:10 UTC+5:30, suman kumar wrote:

 Hi,
 every one..!
 i'm trying to write a macro to create a digital watch in excel please
 guide me..

 Regards,
 @Suman
 Send on the move with Galexy y.

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




-- 
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.comA_html_m691da4f3.gif

Re: $$Excel-Macros$$ Re: share Dashboard Examples/Templates

2012-06-19 Thread pankaj gmail account
Thanks You both Really they are great.

We should share more sample Dashboards in Excel


Regards
Pankaj Michael

On Tue, Jun 19, 2012 at 8:37 PM, Mangesh Vimay mangesh.da...@gmail.comwrote:

 Thanks Noorain for sharing such nice examples..!!!



 On Tue, Jun 19, 2012 at 6:51 PM, NOORAIN ANSARI 
 noorain.ans...@gmail.comwrote:

 PFA


 On Tue, Jun 19, 2012 at 6:49 PM, Mangesh Vimay 
 mangesh.da...@gmail.comwrote:

 Many many thanks for this




 On Tue, Jun 19, 2012 at 6:39 PM, CoRe neculae.vale...@gmail.com wrote:

 Hello Pankaj,

 As far as i know chandoo has greate dashboard templates for free ,

 Attached you can find out a few chandoo dashboards , maybe they skipped
 your eyes.






 On Monday, June 18, 2012 8:31:48 PM UTC+3, panky wrote:

 Dear All,

 Please share Dashboard Examples/Templates

 I already viewed Chandoo's Site so no reference to that site.

 --
 Pankaj Kumar

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




 --
 Thanks  regards,
 Noorain Ansari
 www.noorainansari.com
 www.excelmacroworld.blogspot.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




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




-- 
Pankaj Kumar

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

1) Use concise, accurate thread titles. Poor 

$$Excel-Macros$$ Upgraded to windows 7 - question on personal.xlsb workbook

2012-06-19 Thread LOtto
We have users in my area that are being upgraded from XP to Windows 7 with 
Office 2007 software.  I want to take the macros written for that user, and 
place the workbook (personal.xlsb) in the folder where they will start 
automatically like the old system did.  I tried putting it in the following 
location, but no luck getting it to open. 
 
C:\PROGRAM FILES\MICROSOFT OFFICE\OFFICE12\ - then both xlstart and startup
 
 Is there another file, or location to solve this? 
 
Thanks in advance - Lori
 

-- 
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$$ Need your help !!!

2012-06-19 Thread Mangesh Vimay
Thanks Noorain Bhai,

On Tue, Jun 19, 2012 at 9:08 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:

 see attached sheet


 On Tue, Jun 19, 2012 at 9:06 PM, NOORAIN ANSARI 
 noorain.ans...@gmail.comwrote:

 Dear Mangesh,

 Please try it..

 =VLOOKUP($H9,IF($A$2:$A$10=$H$7,$B$2:$E$10,0),MATCH(I$8,$B$1:$E$1,0),0)
 with ctrl+Shift+enter

 --
 Thanks  regards,
 Noorain Ansari
 www.noorainansari.com
 www.excelmacroworld.blogspot.com


 On Tue, Jun 19, 2012 at 8:59 PM, Mangesh Vimay 
 mangesh.da...@gmail.comwrote:

 Hi Friends, In above example, if we input the name like ABC then it
 should display it's apropriate values
 in the table from the above list.
 Please find the attached sheet.
 How can we find the solution by using Vlookup() function? . Thanks


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










 --
 Thanks  regards,
 Noorain Ansari
 www.noorainansari.com
 www.excelmacroworld.blogspot.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




-- 
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$$ Upgraded to windows 7 - question on personal.xlsb workbook

2012-06-19 Thread Paul Schreiner
Really, it doesn't matter what folder you put it in, 
as long as excel is CONFIGURED to open the files in that folder.

Find out what folder Excel has in the setting open all files in this folder:

Then put Personal.xlsb in that folder.

I have mine on a shared network folder so that it is available at whichever 
computer I'm working on.

 
Paul
-
“Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you can,
To all the people you can,
As long as ever you can.” - John Wesley
-





From: LOtto lscho...@gmail.com
To: excel-macros@googlegroups.com
Sent: Tue, June 19, 2012 1:22:02 PM
Subject: $$Excel-Macros$$ Upgraded to windows 7 - question on personal.xlsb 
workbook


We have users in my area that are being upgraded from XP to Windows 7 with 
Office 2007 software.  I want to take the macros written for that user, and 
place the workbook (personal.xlsb) in the folder where they will start 
automatically like the old system did.  I tried putting it in the following 
location, but no luck getting it to open. 

C:\PROGRAM FILES\MICROSOFT OFFICE\OFFICE12\ - then both xlstart and startup

 Is there another file, or location to solve this? 

Thanks in advance - Lori
-- 
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

$$Excel-Macros$$ Excel Finacial Dash Boards

2012-06-19 Thread P.VIJAYKUMAR
Hello Pankaj,

To get more financial Dashboards and templates visit www.exinfm.com.



Regards,
P.VIJAY KUMAR

-- 
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$$ Introduce Yourself !!

2012-06-19 Thread Nagendra Modupalli
Dear All,

My self Nagendra M and 28 years old. am basically from Andhra
Pradesh.Working in Bangalore as a Finance Analyst fast 7years. I like
very much Excel and this group as well...Thanks you so much knowledge
sharing and helping other's

ThanksRegards
Nagendra.M

Beautiful photos are developed by negatives in a dark room, so if U
see darkness in Ur life believe that God is making a beautiful future
for U !!!

-- 
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$$ Saving Photos from webpage

2012-06-19 Thread Kiran Kancharla
Hi  Chilexcel,

Apologies for delay in response.

As suggested by you, I have tried the steps. It
require manual interaction of click and download the photos.

Experts @ Please create something to make this activity automatic as I have
a huge data to download.

Thanks  Regards,
Kiran



On Sun, Jun 17, 2012 at 11:29 PM, Kiran Kancharla srkira...@gmail.comwrote:

 Hi  *Chilexcel*,

 Thanks for your reply. I will check and let you know at the earliest.


 Thanks  Regards,
 Kiran


 On Sun, Jun 17, 2012 at 10:35 PM, ChilExcel chilexcel...@gmail.comwrote:

 Please see attached

 Used DownThemAll , add on firefox (To use DownThemAll, simply open a
 Web page in Firefox, click Tools from the toolbar,)

 and then use

 Excel Insert Images (Chilexcel) Direct and from Hyperlink
 http://www.youtube.com/watch?v=B1qUrTKsnGofeature=plcp



 Chilexcel



 2012/6/17 Kiran Kancharla srkira...@gmail.com:
 
  Hi All,
 
  Request you to please help to create a Macro to save images folder.
 
  Below are the requirement:
 
  Step 1: Navigating the website : http://www.jabong.com/  - Macro Done
  Step 2 : Search for product :  WR138MA56HVN -  Macro Done
  Step 3 : Select Photos and download the photos in the
 specified location. -
  Macro Require
 
  I have created macro to navigate the web page and I need help to save
 the
  all photos in folder.
 
  Please help me as i have a huge data to download.
 
  I have tried in google, unfortunately I am getting all the macro's to
  download only 1 photo, in my current need I have to download all the
 photos.
 
  I can use any type of explorer ie, chrome, firefox or any.
 
  Note : The website (http://www.jabong.com/)is only for example purpose.
 
  Thanks in advance...
  --
  Thanks  Regards,
  Kiran
 
  --
  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




 --
 Thanks  Regards,
 Kiran
 9920456606




-- 
Thanks  Regards,
Kiran
9920456606

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