londresw
09-18-2008, 01:34 PM
Hi,
I'm trying to use information in a second workbook, "C:\test.xls". So for example, I want to check what info is in cell A1 of the first workbook, "C:\workbook1.xls" put that string into a variable and send it to the second worbook, 'test', and then return a value depending on what that string returns through code in the second workbook.
So for example,
Workbook 1
A1 = sausages
take 'sausages' to test workbook,
search column A for 'sausages' and then, when found in say.. A22, return the value in B22 of test workbook, e.g. 'germany' then return 'germany' to workbook 1 to be used as part of the program, in a variable.
Any ideas?
I'm confident I can right the look-up code but am struggling in the moving of variables from one workbook to another.
Thanks in advance for any help..
Scott
:banghead:
I'm trying to use information in a second workbook, "C:\test.xls". So for example, I want to check what info is in cell A1 of the first workbook, "C:\workbook1.xls" put that string into a variable and send it to the second worbook, 'test', and then return a value depending on what that string returns through code in the second workbook.
So for example,
Workbook 1
A1 = sausages
take 'sausages' to test workbook,
search column A for 'sausages' and then, when found in say.. A22, return the value in B22 of test workbook, e.g. 'germany' then return 'germany' to workbook 1 to be used as part of the program, in a variable.
Any ideas?
I'm confident I can right the look-up code but am struggling in the moving of variables from one workbook to another.
Thanks in advance for any help..
Scott
:banghead: