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
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:
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.Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks