Tim in Toronto
New Member
- Joined
- Nov 18, 2004
- Messages
- 47
Hi All,
I'm using this formula below to populate current inventory levels for product.
ActiveCell.FormulaR1C1 = _
"=VLOOKUP(RC[-15],'[Inventory Week 32 2007.xls]Inventory'!C1:C3,3,FALSE)"
However, what I would like to be able to do, is where it shows the file name "[Inventory Week 32 2007.xls]", I would like to have a message box come up so the user can browse for the file. The file is updated each week but the file is always different as it contains a date in the name.
Is this possible?
Tim
I'm using this formula below to populate current inventory levels for product.
ActiveCell.FormulaR1C1 = _
"=VLOOKUP(RC[-15],'[Inventory Week 32 2007.xls]Inventory'!C1:C3,3,FALSE)"
However, what I would like to be able to do, is where it shows the file name "[Inventory Week 32 2007.xls]", I would like to have a message box come up so the user can browse for the file. The file is updated each week but the file is always different as it contains a date in the name.
Is this possible?
Tim