LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #4   Report Post  
Posted to microsoft.public.excel.programming
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


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Dictator Apps and Excel 2007 Greg Lovern Excel Programming 2 November 17th 08 03:51 PM
Dictator App Gary Brown[_4_] Excel Discussion (Misc queries) 2 October 28th 08 04:49 PM
Making a [semi] Dictator Application: Hiding Main Command Bar? dim Excel Discussion (Misc queries) 4 January 7th 08 11:38 PM
Making a [semi] Dictator Application: Hiding Main Command Bar? dim Excel Programming 4 January 7th 08 11:34 PM
Program question NascarIsKing Excel Programming 3 July 9th 04 03:03 AM


All times are GMT +1. The time now is 09:41 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"