Accessing data stored in the worksheet (named range) in .xla file
Hi,
I'm really not skilled in programming, just what i need for engineering
applications.
I have this spreadsheet with macros and named ranges that i use to achieve
the unit conversion (meters to feet, kilogram to pund, etc,etc).
I want to have the access to the functions in this spreadsheet from several
other workbooks that also performs calculations.
So I thought on conveting my units conversion workbook to an add in, by
saving it as .xla
The problem is that i can not access the named ranges stored in the
worksheets or see them if i do that.
I do not want to loose the flexibility of adding units and conversion
factors in the units conversion worksheet.
The validation of the units entered is also important.
Any Ideas?
|