Results 1 to 2 of 2
  1. #1
    Star Lounger
    Join Date
    May 2009
    Posts
    84
    Thanks
    0
    Thanked 0 Times in 0 Posts

    How to set a .dot file to run on double click from Windows Explorer?

    I made a letterhead.dot template that most users will access through Windows Explorer. When the template runs a date field inserts the current date field, selects it and unlinks the field so it never changes when the .doc is saved (if you have an easier way to do this, I'd appreciate your ideas).

    When a user double-clicksthe .dot file in Windows Explorer, it sometimes opens the .dot file (not good) and sometimes runs the .dot file so a .doc is created (good). I have an AutoEx, AutoNew, and AutoOpen Subs. Is there any code that will insure the template will run on double-click so that a .doc is created? I'd also like to hear any ideas on other ways of doing this.

    Thanks,
    Charlie
    charlie6067

  2. #2
    5 Star Lounger
    Join Date
    Mar 2001
    Location
    New York, NY
    Posts
    922
    Thanks
    2
    Thanked 12 Times in 11 Posts
    There's a field called CreateDate that will add today's date and not subsequently update. With this field, there's no need for macro code to unlink it.

    Double-clicking a template in Windows Explorer should launch the template, not open it. Is there a pattern to the difference (launch/open) that you are seeing? Perhaps you're using Vista O/S as an admin.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •