Opening and closing workbook with VBA...
Hello all,
I have a workbook (workbook 1) in which I am performing a
vlookup calculation using another workbook (workbook 2).
In the macro, I want to open workbook 2, perform the
calculation, and then close workbook 2. Anyone have any
ideas?
Any help is appreciated.
Thanks,
Trevor
|