Referencing funciton to workbook

  • Thread starter Thread starter Juan Sanchez
  • Start date Start date
J

Juan Sanchez

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.
 
Back
Top