Consulting

Results 1 to 2 of 2

Thread: saving changes to xlt doc

  1. #1

    saving changes to xlt doc

    I have an xlt file that is saved in a folder. It is used to create the xls docs in the code. I need to make a change to the template, but simply making a change and saving over the xlt document doesn't seem to work. Am I missing something? Thank you!

    [VBA]tplName = "v:\data\import.xlt"
    Set wb = Workbooks.Add(tplName)[/VBA]

  2. #2
    VBAX Regular
    Joined
    Mar 2005
    Location
    Helena, MT
    Posts
    90
    Location
    Hi:
    I believe you can right click the .xlt file icon in the folder and choose open. This should open the orignal template. Make your changes and resave.

    lenze

Posting Permissions

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