MS SQL Server DTS - Need to find all named ranges in Excel workbook from DTS

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Need to find all named ranges in Excel workbook from DTS

Andy S.

2005-07-19, 9:23 am

I'm trying to write an activex script to read in all the named ranges that
end with a $ in an Excel workbook from a DTS package. I've gotten as far as
grabbing the filename of the excel file. I've been trying to find an answer
without much luck, does anyone have any suggestions?

--

********************
********************
*********
Andy S.
andymcdba1@noreply.yahoo.com

Please remove "noreply" before replying.

********************
********************
*********

pdxJaxon

2005-07-19, 11:23 am

you're gonna need to hit an Excel VBA group for that.

Look up the Excel Object Model in Excel VBA documentation.

I"ve done this type of thing in the past (Years ago), and I think you'll
find it's actually fairly easy (once you get a hold of the Object Model
Documentation).

Greg Jackson
PDX, Oregon

Sponsored Links