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
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
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
>
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
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
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..
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
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
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.
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:
>
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").
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
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
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
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
15 matches
Mail list logo