I have a spreadsheet called, "Materials Codes and Prices.xls", with a sheet
named "Stock".
The sheet named Stock has Four columns containing:
Column A €“ Part numbers (integer)
Column B €“ Description (string)
Column C €“ Price (Double)
Column D €“ Weight (Double)

As new items are added to the list, the number of rows used is for ever
increasing.

How can I upload this ever increasing size of the range into an array into
another instance of Excel?

Thanks

Ashby