+ Reply to Thread
Results 1 to 2 of 2

Custom File Name At Start-up Using Macro-Enabled Template Format (.XLTM) (VBA)

  1. #1
    Registered User
    Join Date
    07-16-2012
    Location
    Maryland, USA
    MS-Off Ver
    Excel 2007
    Posts
    3

    Question Custom File Name At Start-up Using Macro-Enabled Template Format (.XLTM) (VBA)

    So I am trying to make a file that when opened will act as a template does and change the file name on start-up.

    Typically, the template changes the file name by appending one number (e.g. "Book Template REV 1.1.xltm' upon opening would change the file name to 'Book Template REV 1.11.xlsx'). What I want to do, however, is to custom the name change so I could use the file 'Book Template REV 1.1.xltm' while having it change the file name upon opening to 'Custom Name 567.xlsx', without a user being notified of the change (since typically when a template opens the file, the user has no notification that the file name has changed ever so slightly).

  2. #2
    Registered User
    Join Date
    07-16-2012
    Location
    Maryland, USA
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Custom File Name At Start-up Using Macro-Enabled Template Format (.XLTM) (VBA)

    Any thoughts on how to approach changing the naming scheme for a .XLTM?

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1