Importing named ranges

  • Thread starter Thread starter DZ
  • Start date Start date
D

DZ

Hello

I want to use the transfer spreadsheet method to import named ranges from
Excel into Access 97. It works fine. What I need help with is:

I would like to get the list of all named ranges in an Excel workbook so I
can pass these names to the transfer spreadsheet method. I thought of using
automation from Access and create an Excel object etc to get the named ranges
from the workbook. Is there a better/easier way to get those names to pass to
the Transfer Spreadsheet method

Ultimately my goal is to create a utility in Access to import all the named
ranges from an excel workbook into Access. I know how to create a loop to
loop through the named ranges after I get those names and have each instance
of the loop run the transfer spreadsheet method, I'm just looking for an easy
way to get those named ranges out of the workbook

Thanks for any ideas

DZ
 
I believe Automation is the only way you'd be able to get the list of named
ranges.
 
Back
Top