dear excel guru, thanks for the reply and sorry for late reply.
the macro only searches excel files containing the specified word but not pdf or doc file.I do need the same for pdf and doc file. thanks in advance. On 08/06/2011, ashish koul <koul.ash...@gmail.com> wrote: > try this > > rename sheet to rename files > > sheet 1 to search file name using content > > > > On Tue, Jun 7, 2011 at 10:40 PM, <chhajersand...@gmail.com> wrote: > >> To excel gurus >> Pls do something Its become a nightmare sir to me. >> >> Sent on my BlackBerry® from Vodafone >> ------------------------------ >> *From: *chhajersand...@gmail.com >> *Date: *Mon, 6 Jun 2011 18:25:17 +0000 >> *To: *<excel-macros@googlegroups.com> >> *ReplyTo: *chhajersand...@gmail.com >> *Subject: *Re: $$Excel-Macros$$ >> >> Thanks for reply....divya is content of the file.. >> >> Sent on my BlackBerry® from Vodafone >> ------------------------------ >> *From: *"Rajan_Verma" <rajanverma1...@gmail.com> >> *Sender: *excel-macros@googlegroups.com >> *Date: *Mon, 6 Jun 2011 20:09:04 +0530 >> *To: *<excel-macros@googlegroups.com> >> *ReplyTo: *excel-macros@googlegroups.com >> *Subject: *RE: $$Excel-Macros$$ >> >> I Think he want to search the content in file.. >> >> >> >> *From:* excel-macros@googlegroups.com [mailto: >> excel-macros@googlegroups.com] *On Behalf Of *ashish koul >> >> *Sent:* Monday, June 06, 2011 8:07 PM >> *To:* excel-macros@googlegroups.com >> *Subject:* Re: $$Excel-Macros$$ >> >> >> >> you want to search word divya is name of file or in content of file >> >> On Mon, Jun 6, 2011 at 6:50 PM, <chhajersand...@gmail.com> wrote: >> >> Dear excel guru, >> >> I have a unique problem. Few days ago my hard disk was crashed. Now when I >> have recovered all the data,instead of file name assigned to those file, >> system has assigned file no.(i.e. system generated code to every file) I >> have 60000 pdf file to rename. >> Is there any way to write macro which can find a particular word and give >> me the name of such files which contains that particular word! Like if in >> the search criteria I write divya ltd. It will give the all the names of >> the >> file in excel containing word divya ltd. >> >> Thanks in advance. >> Sent on my BlackBerry® from Vodafone >> >> -- >> >> ---------------------------------------------------------------------------------- >> 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 >> >> -- >> >> ---------------------------------------------------------------------------------- >> 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 > -- Regards, Sandeep Kumar Chhajer. Ph. no: 07498171901 09339549906 Wish you all happy new Year 2011. -- ---------------------------------------------------------------------------------- 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
