search for text in another Excel file without opening it

I want search a specified text in other excel file (with password ) without opening it to be viewed by user and get them and values in other columns for it's row ..Waiting for help

Can any one help?

You can use another instance of Excel to open it, without making the instance visible:

Please Login or Register  to view this content.

Between "set wbkhidden "= and "wbkhidden.close", you would put your code to move the data around as you want. Note the code could be changed to show appExcel:

Please Login or Register  to view this content.

so you will want to put in as much protection as you can, maybe protecting the VBA Project.

thank you so much
and could you help me on how can i search for a value in the other sheet and return another value in the same row ?

Originally Posted by wallyeye

You can use another instance of Excel to open it, without making the instance visible:

Please Login or Register  to view this content.

Between "set wbkhidden "= and "wbkhidden.close", you would put your code to move the data around as you want. Note the code could be changed to show appExcel:

Please Login or Register  to view this content.

so you will want to put in as much protection as you can, maybe protecting the VBA Project.

thank you so much
and could you help me on how can i search for a value in the other sheet and return another value in the same row ?

Originally Posted by wallyeye

You can use another instance of Excel to open it, without making the instance visible:

Please Login or Register  to view this content.

Between "set wbkhidden "= and "wbkhidden.close", you would put your code to move the data around as you want. Note the code could be changed to show appExcel:

Please Login or Register  to view this content.

so you will want to put in as much protection as you can, maybe protecting the VBA Project.