Re: $$Excel-Macros$$ how to find a text in a folder

2012-02-25 Thread raghu gr
hi, In folder "xyz" in "abc.xls" i typed 123456, then in agent ransack in "containing search" i typed 123456, but it is not seaching the file abc.xls thanks a lot sir with regards raghu On Sat, Feb 25, 2012 at 11:29 PM, xlstime wrote: > Hi raghu, > > can you share the some data > > > On Sa

Re: $$Excel-Macros$$ how to find a text in a folder

2012-02-25 Thread xlstime
Hi raghu, can you share the some data On Sat, Feb 25, 2012 at 9:44 PM, Sam Mathai Chacko wrote: > Well, then it shouldn't work, should it. You are looking for a number, but > the number is a text. so change all your number texts to actual > numbers. > > Sam > > > On Sat, Feb 25, 2012

Re: $$Excel-Macros$$ how to find a text in a folder

2012-02-25 Thread Sam Mathai Chacko
Well, then it shouldn't work, should it. You are looking for a number, but the number is a text. so change all your number texts to actual numbers. Sam On Sat, Feb 25, 2012 at 9:32 PM, raghu gr wrote: > hi, > > i am using excel 2003 and number is stored in text only sir > > thank you >

Re: $$Excel-Macros$$ how to find a text in a folder

2012-02-25 Thread raghu gr
hi, i am using excel 2003 and number is stored in text only sir thank you On Sat, Feb 25, 2012 at 9:04 PM, xlstime wrote: > which version you are using ? > > > On Sat, Feb 25, 2012 at 7:00 PM, raghu gr wrote: > >> Hi xlstime, >> its working for text only, but for numbers it is not working pls

Re: $$Excel-Macros$$ how to find a text in a folder

2012-02-25 Thread Sam Mathai Chacko
If your numbers are stored as text, it will not work... Sam On Sat, Feb 25, 2012 at 9:04 PM, xlstime wrote: > which version you are using ? > > > On Sat, Feb 25, 2012 at 7:00 PM, raghu gr wrote: > >> Hi xlstime, >> its working for text only, but for numbers it is not working pls help. >> >> wi

Re: $$Excel-Macros$$ how to find a text in a folder

2012-02-25 Thread xlstime
which version you are using ? On Sat, Feb 25, 2012 at 7:00 PM, raghu gr wrote: > Hi xlstime, > its working for text only, but for numbers it is not working pls help. > > with regards > raghu > > > On Wed, Feb 22, 2012 at 9:02 PM, xlstime wrote: > >> please use same software for any data type..

Re: $$Excel-Macros$$ how to find a text in a folder

2012-02-25 Thread raghu gr
Hi xlstime, its working for text only, but for numbers it is not working pls help. with regards raghu On Wed, Feb 22, 2012 at 9:02 PM, xlstime wrote: > please use same software for any data type.. > > > On Wed, Feb 22, 2012 at 12:21 AM, raghu gr wrote: > >> hi, >> >> This is working fine for se

Re: $$Excel-Macros$$ how to find a text in a folder

2012-02-22 Thread xlstime
please use same software for any data type.. On Wed, Feb 22, 2012 at 12:21 AM, raghu gr wrote: > hi, > > This is working fine for searching text, how to search for numbers sir, > > means example if i want search a invoce number 2000127845 in a folder in > which there are 50 files. > > > Thank yo

Re: $$Excel-Macros$$ how to find a text in a folder

2012-02-21 Thread raghu gr
hi, This is working fine for searching text, how to search for numbers sir, means example if i want search a invoce number 2000127845 in a folder in which there are 50 files. Thank you with regards raghu On Mon, Feb 20, 2012 at 11:47 PM, raghu gr wrote: > > hi, > > Thanks this is very good.

Re: $$Excel-Macros$$ how to find a text in a folder

2012-02-20 Thread raghu gr
hi, Thanks this is very good. thank you with regards raghu On Mon, Feb 20, 2012 at 3:11 PM, xlstime wrote: > Hi Raghu, > > > you can use "*Agent Ransack *" searching software > > http://mythicsoft.com/page.aspx?type=agentransack&page=home > > On Sun, Feb 19, 2012 at 11:41 PM, raghu gr wrote: >

Re: $$Excel-Macros$$ how to find a text in a folder

2012-02-20 Thread xlstime
Hi Raghu, you can use "*Agent Ransack *" searching software http://mythicsoft.com/page.aspx?type=agentransack&page=home On Sun, Feb 19, 2012 at 11:41 PM, raghu gr wrote: > Sir, > > > Sir some error in line, > > Set a = wk.Cells.Find(What:="*" & ThisWorkbook.Sheets("File > Names").Range("c2").

Re: $$Excel-Macros$$ how to find a text in a folder

2012-02-19 Thread raghu gr
Sir, Sir some error in line, Set a = wk.Cells.Find(What:="*" & ThisWorkbook.Sheets("File Names").Range("c2").Value & "*", After:=wk.Cells(1, 1), _ LookIn:=xlFormulas, LookAt:=xlPart, SearchOrder:=xlByRows, _ SearchDirection:=xlNext, MatchCase:=False) pls help me. Thank you Raghu -- FORUM RUL

Re: $$Excel-Macros$$ how to find a text in a folder

2012-02-18 Thread raghu gr
Sir, vow instant reply, great!! but i am getting error in line Set a = wk.Cells.Find(What:="*" & ThisWorkbook.Sheets("File Names").Range("c2").Value & "*", After:=wk.Cells(1, 1), _ LookIn:=xlFormulas, LookAt:=xlPart, SearchOrder:=xlByRows, _ SearchDirection:=xlNext, MatchCase:=False) pls hel

Re: $$Excel-Macros$$ how to find a text in a folder

2012-02-18 Thread NOORAIN ANSARI
Dear Raghu, Plwase try it.. Dim j As Long Dim fldpath Dim fld, fil, subfld As Object Sub search_workbooks() Application.DisplayAlerts = False Application.ScreenUpdating = False '* to get file names in folder Application.FileDialog(msoFileDialogFolderPicker).Title = "Choose Fo

$$Excel-Macros$$ how to find a text in a folder

2012-02-18 Thread raghu gr
hi all, how to find a text in folder. Example - suppose in 1 folder there are 40 excel files, if i want find a text "apple" is in which file (as it becomes tedious to open each and every file and use ctrl +F option). with regards raghu -- FORUM RULES (986+ members already BANNED for violation