from:"Iqbal Merchant"

Re: $$Excel-Macros$$ pls help in conditional formating

2012-07-13 Thread Iqbal Merchant

Please share the code.

Regards

Iqbal M

On Fri, Jul 13, 2012 at 5:15 AM, ChilExcel chilexcel...@gmail.com wrote:

 Hi Mohammed

 Please see attached file, I think is what you need


 Chilexcel


  2012/7/12 Mohammed Hamed Ajaz mhameda...@gmail.com

 Pls help in conditional formatting

 Example

 Column A Column B name Column C due date   columne  D last
 due date

 5/7/12  colony

 pls provide me a formula so that column c and column d should turn yellow
 and red respectively after 20 and 30 days considering Column A Date as
 basis.

 awaiting for the forumla

 as i have already told i am basic learner of excel

 which u experts can understand with query that i have asked and help in
 providing this formula as well as other formula to have good command on
 excel

 thanks

 best regards.

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




-- 
Regards

Iqbal Merchant
+919833567656

-- 
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: Convert XLS to XML

2011-12-12 Thread Iqbal Merchant

Hi Gurus,
Kindly help for the below query.

Regards,

Iqbal

On Fri, Dec 9, 2011 at 12:35 PM, Iqbal Merchant iqbalmerch...@gmail.comwrote:

 Hi Gurus,
 I need a macro to convert the content of the file into xml format and the
 converted file should get saved on desktop in .xml format.
 Sample file attached.
 Please help!
 --
 Regards

 Iqbal Merchant





-- 
Regards

Iqbal Merchant

-- 
FORUM RULES (934+ 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

$$Excel-Macros$$ Convert XLS to XML

2011-12-08 Thread Iqbal Merchant

Hi Gurus,
I need a macro to convert the content of the file into xml format and the
converted file should get saved on desktop in .xml format.
Sample file attached.
Please help!
-- 
Regards

Iqbal Merchant

-- 
FORUM RULES (934+ 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


Input_Sheet.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Excel learning Institute

2011-11-25 Thread Iqbal Merchant

Where in Andheri (east).
Anybody near Thane.?

Regards,

Iqbal

On Thu, Nov 24, 2011 at 2:37 PM, krishnanm2...@gmail.com wrote:

 **
 Andheri east


 Sent on my BlackBerry® from Vodafone
 --
  *From: *mangesh bavalekar bavalek...@gmail.com
 *Sender: *excel-macros@googlegroups.com
 *Date: *Thu, 24 Nov 2011 14:16:44 +0530
  *To: *excel-macros@googlegroups.com
 *ReplyTo: *excel-macros@googlegroups.com
 *Subject: *Re: $$Excel-Macros$$ Excel learning Institute

 where I can learn advance excel.im mumbai ?




  Mangesh V. B.


 --
 FORUM RULES (934+ 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

 --
 FORUM RULES (934+ 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




-- 
Regards

Iqbal Merchant
+919833567656

-- 
FORUM RULES (934+ 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

Re: $$Excel-Macros$$ I want customised web query in excel

2011-06-23 Thread Iqbal Merchant

Hi, Kindly disable the macro security to run the macros.
I tired its working.

Regards,

IM

On Wed, Jun 22, 2011 at 10:18 PM, sharad jain jainshar...@gmail.com wrote:

 I have alread tried that.

 I have put date range as 1-Jun-2010 to 21-Jun-2011.

   On Wed, Jun 22, 2011 at 9:17 PM, ashish koul koul.ash...@gmail.comwrote:

 chage the date  in cell d2 and f2

 and client in b2 and then run the macro


 On Wed, Jun 22, 2011 at 7:35 PM, sharad jain jainshar...@gmail.comwrote:

 Thanks Ashish,

 But the file only gets the data from 10-Jun-2010 to 19-Oct-2010.

 Also can you please let me know how create this type of macro?

 Thanks,
 Sharad

   On Wed, Jun 22, 2011 at 7:18 PM, ashish koul koul.ash...@gmail.comwrote:

 try this


 On Wed, Jun 22, 2011 at 5:59 PM, Ketan research.ke...@gmail.comwrote:

  Dear Members,

 ** **

 I have attached file which has macro to fetch data from NSE website **
 **

 ** **

 In that I want that query to be customized like date range to change
 and company name also changed 

 So that I can fetch data in excel by changing date range and symbol***
 *

 ** **

 Ketan Yadav

 ** **

 --

 --
 Some important links for excel users:
 1. Follow us on TWITTER for tips tricks and links :
 http://twitter.com/exceldailytip
 2. Join our LinkedIN group @
 http://www.linkedin.com/groups?gid=1871310
 3. Excel tutorials at http://www.excel-macros.blogspot.com
 4. Learn VBA Macros at http://www.quickvba.blogspot.com
 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

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

 
 Like our page on facebook , Just follow below link
 http://www.facebook.com/discussexcel




 --
 *Regards*
 * *
 *Ashish Koul*
 *akoul*.*blogspot*.com http://akoul.blogspot.com/
 http://akoul.posterous.com/
 *akoul*.wordpress.com http://akoul.wordpress.com/
 My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830


 P Before printing, think about the environment.


 --

 --
 Some important links for excel users:
 1. Follow us on TWITTER for tips tricks and links :
 http://twitter.com/exceldailytip
 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
 3. Excel tutorials at http://www.excel-macros.blogspot.com
 4. Learn VBA Macros at http://www.quickvba.blogspot.com
 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

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

 
 Like our page on facebook , Just follow below link
 http://www.facebook.com/discussexcel


 --

 --
 Some important links for excel users:
 1. Follow us on TWITTER for tips tricks and links :
 http://twitter.com/exceldailytip
 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
 3. Excel tutorials at http://www.excel-macros.blogspot.com
 4. Learn VBA Macros at http://www.quickvba.blogspot.com
 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

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

 
 Like our page on facebook , Just follow below link
 http://www.facebook.com/discussexcel




 --
 *Regards*
 * *
 *Ashish Koul*
 *akoul*.*blogspot*.com http://akoul.blogspot.com/
 http://akoul.posterous.com/
 *akoul*.wordpress.com http://akoul.wordpress.com/
 My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830


 P Before printing, think about the environment.


 --

 --
 Some important links for excel users:
 1. Follow us on TWITTER for tips tricks and links :
 http://twitter.com/exceldailytip
 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
 3. Excel tutorials at http://www.excel-macros.blogspot.com
 4. Learn VBA Macros at http://www.quickvba.blogspot.com
 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

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

 
 Like our page on facebook , Just follow below link
 http://www.facebook.com/discussexcel


 --

 --
 Some important links for excel users:
 1. Follow us on TWITTER for tips tricks and links :
 http://twitter.com/exceldailytip
 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
 3. Excel tutorials at http://www.excel-macros.blogspot.com
 4. Learn VBA Macros at http://www.quickvba.blogspot.com
 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

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

 
 Like our page on facebook , Just follow below link
 http://www.facebook.com/discussexcel




-- 
Thanks  Regards

Iqbal Merchant
+919833567656
+919551868584

Re: $$Excel-Macros$$ Ayush Jain – Microsoft MVP 20 10

2010-10-03 Thread Iqbal Merchant

Congrate, i feel i have made the right decision by becoming member of this
group.

On Sun, Oct 3, 2010 at 5:10 PM, Dave Bonallack davebonall...@hotmail.comwrote:

And from me too, Ayush, congratulations! Very good service you provide
here. Lots of work and time behind the scenes. Thank-you.
Dave.

--
From: shubhangidesa...@gmail.com
Date: Sun, 3 Oct 2010 16:46:13 +0530
Subject: Re: $$Excel-Macros$$ Ayush Jain – Microsoft MVP 2010
To: excel-macros@googlegroups.com

Congratulations Mr Ayush

We r proud to have u here...

On Sun, Oct 3, 2010 at 3:56 PM, ashish koul koul.ash...@gmail.com wrote:

congrats ayush.

On Sun, Oct 3, 2010 at 3:47 PM, Ayush jainayus...@gmail.com wrote:

Dear Group,

I am proud to announce that I am awarded Microsoft Most Valuable
Professional MVP on October 01, 2010 for providing technical expertise
in Excel technical communities for past one year.

http://blogs.technet.com/b/southasiamvp/archive/2010/10/01/new-mvps-announced-october-2010.aspx

This is a prestigious award from Microsoft given every Quarter to the
people who share their deep knowledge, real-world experience, and
impartial, objective feedback to help people enhance the way they use
technology.

My deep thanks to each group member for all your support and
contribution to this group.

Best regards,
Ayush Jain
Microsoft MVP

--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com