Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
use VBA to create UDF to lookup value in a closed spreadsheet
Hi,
I've been looking around quite a bit for this and I keep running into comments that state you cannot search a closed spreadsheet. I have a file on a network drive that contains a mapping of item number to description. I'd like to have a distributable add-in (.xla) file with a function in it that allows a user to put in a simple formula to lookup these values. Currently, every user has their own local spreadsheet which is a snapshot taken at differing times and is subject to inconsistencies. My thought was to create a formula so we can say =sku_description(<sku number) People are using VLOOKUP and INDEX MATCH with mixed success. Here is one tip that almost works for me: http://www.exceltip.com/st/Read_info...Excel/473.html This tip is nice, but I'm missing why we can't do some kind of workbook.Open to activate the workbook and then close it afterward? As you may have guessed, I'm a rookie when it comes to VBA but I've worked in a couple of other languages. Thanks for any suggestions you can offer. I really appreciate the generosity of your responses. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can i create an index/ match formale for spreadsheet or a lookup | Excel Discussion (Misc queries) | |||
Lookup last used Row un closed Workbook | Excel Worksheet Functions | |||
Lookup function Closed files Excel | Excel Worksheet Functions | |||
Excel spreadsheet is closed | Excel Programming | |||
Lookup up cell value in closed sheet | Excel Programming |