Thread: refer to dynamic range in closed workbook with ADO
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
MattShoreson[_21_] MattShoreson[_21_] is offline
external usenet poster
  
Posts: 1
Default refer to dynamic range in closed workbook with ADO

Eric,

Thanks for the answer. That's the road I took. Resizing and renamin
the ranges on closing.

Tom, the whole reason for using ADO was in order not to open th
workbook thereby making the workbook invisble to the user.
Screenupdating wouldn't cut the mustard either. Cheers for th
response though

--
MattShoreso
-----------------------------------------------------------------------
MattShoreson's Profile: http://www.excelforum.com/member.php...nfo&userid=347
View this thread: http://www.excelforum.com/showthread.php?threadid=37703

Reply With QuoteReply With Quote