Auto Data Input from a Closed File

[rvalasho]

I want to import data from a closed Excel file into an active file. I
know Walkenbach developed the GETVALUE UDF for that purpose, but I
wonder if there are alternatives available.

My goal is to have a user select the data required from a drop down box
and that subsequently the correct data is imported into the correct
area in the active worksheet.

Thanks

Jack

 

[Dave Peterson]

Maybe you could have a hidden sheet with formulas that retrieve the values from
that closed workbook.

Then you could use Data|Validation and use the range on that worksheet as the
source of the list.