Opening file in existing workbook

B

bLySs

Hi,
I'm just wondering if it's possible to open an existing excel file, on
that i've saved earlier, directly into a workbook that i have open o
screen.

I'm running a macros that requires me to have a vlookup table, however
each time the macros runs a different file will be selected. I need th
new, macros opened file to recognise the table from my previou
workbook that contains my vlookup table. Or, someway to import m
vlookup table into the new, macros opened file.
I'm not sure if this is clear?

Much appreciated,
bLyS
 
B

Bernie Deitrick

bLySs,

Have an area in your workbook with the macros where you can paste a copy of
your data from the newly opened file, and have all your formulas refer to
that area. Copy and pastespecial values will work, as will a macro that does
the copying for you.

HTH,
Bernie
MS Excel MVP
 
Top