Dear Mandeep Sir
Wow.
Perfect,You are done it………
I am really thankful for its wonderful VBA Coding. Sorry for late reply due
to heavy workload.
It's Great output for this Group.
Regards
Amar
On Tue, Jan 19, 2016 at 4:51 PM, Mandeep Baluja
wrote:
> Check this out and let me know !!
Check this out and let me know !! Regards, Mandeep baluja
Sub SearchDir()
Dim i As Long: i = 2 'A variable to paste values in main
sheet
Dim Searchword As Variant 'Search value to be used
Dim Wbmain As Workbook 'Main workbook
Dim fldAs Object
Hey,
I understood you're question that's why I replied bro. Okay let me tell you
a trick.
> Go to that folder open in window explorer on right side you will see the
> search option enter the number you're are looking for it will show you
> those files which contains the text present anywher
Dear Mandeep
Thanks for reply but i think you not get my Question properly,i am little
confused.I explain again it
Suppose in one folder there are more than 100 excel data sheet & i want to
search specific word or number which is kept in that 100 sheet but i dont
know which excel sheet it is in k
>
> This can be achieved easily with the VBA code, Why don't you give it a Try
> to loop files reside in folder and open it and checking all sheets one by
> one and use find method to search for specific keywords.
>
Regards,
Mandeep baluja
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel?
