Macro of the day : Excel VBA macro for searching data from closed excel file

[Excel VBA Lab]

Hi All,

Macro of the day..

If you ever wish to browse through closed file search for some data & pop up on screen??

Refer attach file, macro will ask you for string to search & as per data given from particular sheet macro will mtchh criterion & will return content of the 1st cell in which data found & content next to it..

You need to give reference to library by pressing Alt + F11, then Tools reference:

Microsoft ActiveX data Object 6.1 Library & Microsoft DAO 3.51 or higher 

Lets Get set Go!

[Ashu K]

Dear vaibhav sir,

nice work, thanks for sharing this

Thanks & Regards

Ashu kenith