Would like to retrieve values from an external file using VLOOKUP

hi all,

Is it possible to retrieve a value from an external excel file using Excel
97 SR2?

We have created a pricing.xlt template containing VLOOKUP function that
retrieves information from an external Excel file named _bpcs_pricing.xls

Upon creating a file pricing1.xls based on the template, we would like to
save this file containing "values" retrieved from _bpcs_pricing.xls as
opposed to a dynamic link.

Any assistance in how to achieve above will be appreciated.

thank you

--
Trajano Roberto

Trajano Roberto wrote:
Upon creating a file pricing1.xls based on the template, we would like to
save this file containing "values" retrieved from _bpcs_pricing.xls as
opposed to a dynamic link.


Is this when you are saving the file or when you have just opened it?
I assume on saving.

Manually you would select the formulas,
Edit / Copy
Edit / Paste Special / Values

You could write a macro to do that on saving the file (Workbook_BeforeSave
in the ThisWorkbook module), but then you would get the macro warning on
opening the template.


Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup