Opening file in existing workbook

  • Thread starter Thread starter bLySs
  • Start date Start date
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
 
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
 
Back
Top