Re: $$Excel-Macros$$

2010-01-29 Thread khalid khan
Book name is Micro Soft Bible On Mon, Jan 25, 2010 at 4:43 PM, Shilpa Rao wrote: > Hello, > > Please provide me any material to learn VBA codings. Advance thanks to all > the experts for your help. . > > Regards, > Shilpa > > > On Mon, Jan 25, 2010 at 4:39 PM, Shilpa Rao wrote: > >> Thankyou Da

$$Excel-Macros$$ Pivot table output to pdf with multiple page fields

2010-01-29 Thread TheoMa
Hi, I have a pivot table with 3 page fields, PageF1, PageF2 and PageF3 Each has a number of values including (All) I want to go through every combination of the pagefields and if the pivot table has actual values in the data region to output to a pdf file with a filename format: Pagef1 - PageF2 -

Re: $$Excel-Macros$$ Re: Password crecker for Excel workbbok

2010-01-29 Thread Nandkumar kakvipure
hello ankur, me sirf itanahi kar pa raha hu ye kahase download kiya he muje iska password batana ise 40bit RC4 Encryption protection diya he agar tume malum he to muje jara batana Decryptum Preview*Sheets: *Sheet1 | Sheet2 | Sheet3 *Previewing: *Sheet1 -- Kindly

Re: $$Excel-Macros$$ Macro For Filter by Colour or Comments

2010-01-29 Thread ashish koul
hi check the attachment after this you can filter it manually or if you want it to be done by vba then let me know On Thu, Jan 28, 2010 at 11:27 PM, maulik desai wrote: > Hi > > I want a macro that can do a filter data by comments & filter data by > colour > > -- > Thanks & Regards, > Maulik Desa

Re: $$Excel-Macros$$ Help!!!!!!!!!!!!!

2010-01-29 Thread ankur
very good approach by vinod krishnan , i think your query has been solved , if not plz explain more about it On 29/01/2010, Vinod N wrote: > Hi Gopi, > > PFA the solution... > > Thanks > Vinod > > On Fri, Jan 29, 2010 at 9:15 PM, krishnan Gopi wrote: >> Hello All, >> >> Please find attached th

Re: $$Excel-Macros$$ need help urgently from excel to word

2010-01-29 Thread ankur
hi ashish i dont know how to export data in the abovesaid format, taking my code as base other members can modify as per needlet see On 29/01/2010, ashish koul wrote: > thanks a lot bro ... but is it possible to make changes in it so that i can > get the result in in the format attched in

$$Excel-Macros$$ update sheet row & sumif offset

2010-01-29 Thread manoj kukreja
Hi All, PFA excel working ,que is there Regards Manoj -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Vid

Re: $$Excel-Macros$$ Help!!!!!!!!!!!!!

2010-01-29 Thread Vinod N
Hi Gopi, PFA the solution... Thanks Vinod On Fri, Jan 29, 2010 at 9:15 PM, krishnan Gopi wrote: > Hello All, > > Please find attached the excel i have explained the issue. > > Thanks a lot in advance. > > Regards > Gopi Krishnan > > > -- > ---

Re: $$Excel-Macros$$ Auto Filter using Macro or Formula

2010-01-29 Thread ashish koul
Hi check the attachment On Fri, Jan 29, 2010 at 8:43 AM, Sandip Patel wrote: > Hi Friends, > > I have 10,000 rows excel sheet which has many column as well. > > I want to create a Macro or Formula which will filter the data by *“Type”*, > in the separate sheet, from the file > *“ORIGINAL DATA”

Re: $$Excel-Macros$$ Help!!!!!!!!!!!!!

2010-01-29 Thread madhu nair
Gopi, Enter your value in the yellow sheet and you would see the answer in the next column does it help ? Regards, Madhu Nair On Fri, Jan 29, 2010 at 9:15 PM, krishnan Gopi wrote: > Hello All, > > Please find attached the excel i have explained the issue. > > Thanks a lot in advance. > > R

$$Excel-Macros$$ Help!!!!!!!!!!!!!

2010-01-29 Thread krishnan Gopi
Hello All, Please find attached the excel i have explained the issue. Thanks a lot in advance. Regards Gopi Krishnan -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links :

Re: $$Excel-Macros$$ need help urgently from excel to word

2010-01-29 Thread ashish koul
thanks a lot bro ... but is it possible to make changes in it so that i can get the result in in the format attched in word document in the first mail On Fri, Jan 29, 2010 at 4:34 PM, ankur wrote: > hi ashish > sorry for late reply > > plz check the attached file , this will help u ..u can

Re: $$Excel-Macros$$ he need help

2010-01-29 Thread Ashish Pahuja
Hi Ashish, Any specific rason to fetch date info from website, can you not convert the info locally? Following site and the respective module might help you. http://www.cpearson.com/Excel/TimeZoneAndDaylightTime.aspx Do let me know if you any more help in this. regards Ashish On Fri, Jan 29,

Re: $$Excel-Macros$$ sound with command button

2010-01-29 Thread ankur
hi memonkavi plz check this link, ur query will be solved http://j-walk.com/ss/excel/tips/tip59.htm On 29/01/2010, memonkavi wrote: > sir > how can add sound in a command button in excel vb? > pls help me > > -- > --

$$Excel-Macros$$ Re: he need help

2010-01-29 Thread ashish koul
any help please On Fri, Jan 29, 2010 at 2:16 PM, ashish koul wrote: > http://free.timeanddate.com/clock/i1wel3cw/n176/tt0 > > HI i need a vba solution which will browse above

$$Excel-Macros$$ sound with command button

2010-01-29 Thread memonkavi
sir how can add sound in a command button in excel vb? pls help me -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tut

Re: $$Excel-Macros$$ need help urgently from excel to word

2010-01-29 Thread ashish koul
need help on this matter On Thu, Jan 28, 2010 at 6:47 PM, ashish koul wrote: > hi > > i have a list in excel file with company name website etc, information a > > > and want to put the same in word as i have given in the word format > > > please can anyone give me the vba coding for the same > >

$$Excel-Macros$$ he need help

2010-01-29 Thread ashish koul
http://free.timeanddate.com/clock/i1wel3cw/n176/tt0 HI i need a vba solution which will browse above site and assign its data a= cureent time whatever is there lets suppose

Re: $$Excel-Macros$$ How to save data from html to excel.

2010-01-29 Thread Hemant K
Can you send that html file Regards Hemant On Thu, Jan 28, 2010 at 9:17 PM, Murtaza Dalal wrote: > Naah Ankur it didnt serve the purpose. I've created an HTML page. is there > an HTML code for saving data in excel. > > On Wed, Jan 27, 2010 at 12:18 PM, ankur wrote: > >> hi Murtaza Dalal >> the f

Re: $$Excel-Macros$$ IF statement logic

2010-01-29 Thread ankur
hi dave i dont find attached sheet..plz attach it again On 29/01/2010, Dave Bonallack wrote: > > Hi Captain, > "I have attached a simple spreadsheet" > Almost. > Regards - Dave > >> Date: Thu, 28 Jan 2010 16:05:23 -0800 >> Subject: $$Excel-Macros$$ IF statement logic >> From: capted...@googlema

Re: $$Excel-Macros$$ Using IF Condition

2010-01-29 Thread Vinod N
Hi Gopi, Please find attached few (say5) solution If the attached solution does not solve your query.. please attach a sample file for better understanding and exact solution to your query... Thanks Vinod On Thu, Jan 28, 2010 at 11:29 PM, krishnan Gopi wrote: > Hello All, > > It will be gr

Re: $$Excel-Macros$$ How to save data from html to excel.

2010-01-29 Thread ankur
hi murtaza its ok...let c the reply of other group member On 28/01/2010, Murtaza Dalal wrote: > Naah Ankur it didnt serve the purpose. I've created an HTML page. is there > an HTML code for saving data in excel. > > On Wed, Jan 27, 2010 at 12:18 PM, ankur wrote: > >> hi Murtaza Dalal >

Re: $$Excel-Macros$$ Re: Password crecker for Excel workbbok

2010-01-29 Thread ankur
hi nandkumar i m waiting for ur reply On 28/01/2010, Dilip Pandey wrote: > Dear Maulik, > > I would suggest to search google or other search engines for "Free Excel > Password Breaker", alternatively you can purchase the Office Password > Cracker from open market. > There are some paid websites

Re: $$Excel-Macros$$ Removing password in a macro

2010-01-29 Thread ankur
hi nandkumar plz tell me which software u r using, can u mail me that one On 28/01/2010, Dilip Pandey wrote: > Dear Robinson, > > Password has been removed from the attached file. > > Best Regards, > -- > DILIP KUMAR PANDEY >MBA-HR,B COM(Hons.),BCA > Mobile: +91 9810929744 > dilipan...@gmail

Re: $$Excel-Macros$$ Using IF Condition

2010-01-29 Thread ankur
hi krishnan your query seems to be easy, i thing format of cell can help you, otherwise plz attach your sample sheet On 28/01/2010, krishnan Gopi wrote: > Hello All, > > It will be great, if some one can help me with a IF condition or any other > method to solve the query. > > For Example if dat

RE: $$Excel-Macros$$ IF statement logic

2010-01-29 Thread Dave Bonallack
Hi Captain, "I have attached a simple spreadsheet" Almost. Regards - Dave > Date: Thu, 28 Jan 2010 16:05:23 -0800 > Subject: $$Excel-Macros$$ IF statement logic > From: capted...@googlemail.com > To: excel-macros@googlegroups.com > > Hi there > > I have attached a simple spreadsheet with a tabl