Im trying to write up a funtion on vba that will give an
answer based on a workbook saved on a specific path on my
pc. How do I call a fixed workbook up on a function.

The function will look for a value always in this
spreadsheet, and will work like a double vlookup, the
matrix where it will look up has colums Date | Bench | Part
the output of the function will be the part when I give
Date & Bench i.e. =Part(date,bench) on excel will give the
part that was produced on that day and bench per the
hidden workbook database.

Any help is greatly apreciate.

Regards
JS

Just have the macro open the workbook and extract the data.

You won't be able to use this as a worksheet function, however.

If you need to use this capability in a worksheet, you need to concatenate
the date and part together in the leftmost column so you can use a vlookup
function directly and skip the macro.

--
Regards,
Tom Ogilvy

"Juan Sanchez" wrote in message
...
Im trying to write up a funtion on vba that will give an
answer based on a workbook saved on a specific path on my
pc. How do I call a fixed workbook up on a function.

The function will look for a value always in this
spreadsheet, and will work like a double vlookup, the
matrix where it will look up has colums Date | Bench | Part
the output of the function will be the part when I give
Date & Bench i.e. =Part(date,bench) on excel will give the
part that was produced on that day and bench per the
hidden workbook database.

Any help is greatly apreciate.

Regards
JS

Thanks Tom. That's what I thought, just wanted to check.

Regards
JS


-----Original Message-----
Just have the macro open the workbook and extract the
data.

You won't be able to use this as a worksheet function,
however.

If you need to use this capability in a worksheet, you
need to concatenate
the date and part together in the leftmost column so you
can use a vlookup
function directly and skip the macro.

--
Regards,
Tom Ogilvy

"Juan Sanchez" wrote in
message
...
Im trying to write up a funtion on vba that will give an
answer based on a workbook saved on a specific path on
my
pc. How do I call a fixed workbook up on a function.

The function will look for a value always in this
spreadsheet, and will work like a double vlookup, the
matrix where it will look up has colums Date | Bench |
Part
the output of the function will be the part when I give
Date & Bench i.e. =Part(date,bench) on excel will give
the
part that was produced on that day and bench per the
hidden workbook database.

Any help is greatly apreciate.

Regards
JS


.