Hi Trevor

Start by recording a macro while doing it and see what it gives you.

--
HTH. Best wishes Harald
Followup to newsgroup only please.

"Trevor" wrote in message
...
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