Search & Copy Data without Open Workbook

  • Hi,

    Need some help here, i want to search and copy data, below vb code did what i want on same workbook but i have one question here, let say the data stored in another workbook, how can i search and copy the data without open the workbook? what is the additional vb code and how to integarte with vb code below.

    would appreciate your help.