View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Peter T Peter T is offline
external usenet poster
 
Posts: 5,600
Default Dictator program question

"Jon Peltier" wrote in message

<snip
2. Routine in dictator's Workbook_Open code that detects whether other
windows are open and visible, and if so it opens a new instance and
reopens itself in that instance. I recall that there was a trick to this
one, and unfortunately I can't find the project now where I did this.


Not sure if there's any particular trick, simply re-open itself in a new
automated instance, then close itself in the current instance. It would end
up being read-only, which may or may not be a problem. I posted a quick
example here.

http://tinyurl.com/dxgzbb

Regards,
Peter T