View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
noiseberg noiseberg is offline
external usenet poster
 
Posts: 1
Default 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?