Re: $$Excel-Macros$$ Database Connecting problem

2009-12-23 Thread Mahavir Bhardwaj
Hi abhishek, i dont know that it was working or not. my os is 32 bit.. Mahavir 2009/12/23 Abhishek Jain > Hi Mahavir, > > > Was the connection working in the past ? > > Is the OS you are using is 64 bit ? > > Krgrds, > > Aj > > On Wed, Dec 23

$$Excel-Macros$$ Database Connecting problem

2009-12-22 Thread Mahavir Bhardwaj
Dear All, I am tring to import some data from other applications such as Access & Tally but when i connect it to them *[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified* Message is coming. Please give any solution. Mahavir Singh -- ---

Re: $$Excel-Macros$$ Re: Replace contents in a formula used for whole sheet.

2009-11-25 Thread Mahavir Bhardwaj
Dear Nikhil, if it is the same formula u used for 3000 times then copy the complete formula then press CTRL+H paste in 'FIND WHAT' column then go to 'Replace with' column then paste again and change "M" to "A" and press Replace All. it will replace all you want. Try it Regards Vir 2009/11/25 d

Re: $$Excel-Macros$$ Pivot Table Help count

2009-11-24 Thread Mahavir Bhardwaj
Pls clear your question & make excel sheet with your data & query and attach with this mail. Vir 2009/11/25 subhash tambe > Dear all, > > > How to compile to excel pivot table , > ( B Column Count 5 to 15 ) > > A B C D E F G H > 1 > 2 10 > 3 25 >

Re: $$Excel-Macros$$ Change Date Format

2009-11-24 Thread Mahavir Bhardwaj
hi, do as following Select the column in which date is there, press ALT+D then E, convert text to column will appear press next then next once again, select date option then finish. thanks vir 2009/11/24 Nandkumar kakvipure > Hello, > Please Help me > my system generate date format 14/10/09

Re: $$Excel-Macros$$ Conditional Formating

2009-11-23 Thread Mahavir Bhardwaj
thanks 2009/11/23 Mudassar Ramzan > Dear Mahavir, > take a look on attached file. > > > *Regards,* > ** > *Mudassar Ramzan* > > - Original Message - > *From:* Mahavir Bhardwaj > *To:* excel-macros@googlegroups.com > *Sent

$$Excel-Macros$$ Conditional Formating

2009-11-23 Thread Mahavir Bhardwaj
Dear All, I want to highlight friday and saturday using conditional formating: *A B* DateDay 01/11/2009 =weekday(a1) 02/11/2009 =weekday(a2) 03/11/2009 =weekday(a3) 04/11/2009 =weekday(a4) 05/11/2009 =weekday(a5) 06/11/2009 =weekday(a6

Re: $$Excel-Macros$$ Re: Count of Text

2009-11-22 Thread Mahavir Bhardwaj
Dear All please find enclosed herwith a file with my problem. Pls help Mahavir 2009/11/21 Aindril De > Attach a file in reply to this email.. > > > On Fri, Nov 20, 2009 at 3:55 PM, mahavir wrote: > >> >> i dont know how to attached file. pls tell me the procedure >> >> Mahavir >> >> >> On Nov

$$Excel-Macros$$

2009-11-22 Thread Mahavir Bhardwaj
Pls see attachment -- - -- (¨`•.•´¨) Always `•.¸(¨`•.•´¨) Keep (¨`•.•´¨)¸.•´ Smiling! `•.¸.•´ Best regards, Veer -- -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free