View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
GS[_2_] GS[_2_] is offline
external usenet poster
 
Posts: 3,514
Default Reference named range in closed workbook

Hello,

Is there a way to retrieve all the named ranges names in a CLOSED
workbook then, picking one of them, copy its content to the
clipboard?

Remark: without opening the wbk...


Thanks
Avi


You can do this via ADODB! Here's something that'll get you started...

http://www.appspro.com/conference/Da...rogramming.zip

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion