Zod
08-11-2005, 08:21 AM
Hi everyone! 1st Post!!
Alrighty then, I'm currently attempting to read some data from a closed workbook in a different directory. I'll explain further...
I have a text box for users to enter a name into, this is held on the Master workbook - Names are held along with other data on a row in a separate workbook - And this is the data I need to search on - If the textbox data is found then I need to return the row to the master workbook - Does this make sense???
Techy bit..
Workbook 2 is read only.
The Workbook 2 sheet name will change every month to the months name e.g. July, August etc.
Workbook 2 contains data from columns A through to M
Names are held on Column D starting from D4 and going down to around D4000
There will be more than one instance of the name and I'd like to be able to return all instances into the Master workbook
In the Master Workbook, my textbox is called txtName and it has a command button called cmdSearch - I would like to return the data to Sheet2 in the Master Workbook
I hope this covers all areas and someone can offer some aid! : pray2:
Many thanks!
Zod.
Alrighty then, I'm currently attempting to read some data from a closed workbook in a different directory. I'll explain further...
I have a text box for users to enter a name into, this is held on the Master workbook - Names are held along with other data on a row in a separate workbook - And this is the data I need to search on - If the textbox data is found then I need to return the row to the master workbook - Does this make sense???
Techy bit..
Workbook 2 is read only.
The Workbook 2 sheet name will change every month to the months name e.g. July, August etc.
Workbook 2 contains data from columns A through to M
Names are held on Column D starting from D4 and going down to around D4000
There will be more than one instance of the name and I'd like to be able to return all instances into the Master workbook
In the Master Workbook, my textbox is called txtName and it has a command button called cmdSearch - I would like to return the data to Sheet2 in the Master Workbook
I hope this covers all areas and someone can offer some aid! : pray2:
Many thanks!
Zod.