Results 1 to 2 of 2
  1. #1
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Creating Worksheet Templates-A success (XL97 --->)

    Hi All

    Some of you maybe aware that have responded to my various questions over the last few months that I have been trying to create a set of Workbooks that create templated worksheets that can be sent to a drive folder and later consolidated using another workbook <post#=389440 >post 389440 </post#>.

    First, I want to thank the HansV, Brook and Legare for their patience as I was making some stupid mistakes and secondly I thought I would post it here if people wanted to use it for future use. You will have to go into the code and change the Directory path to get it to work on your PC though.

    The front page has a list of 200 Offices, this list can be changed from 2 to 200 entries, just make sure you have an incremental list in the left column. I am sure it can beimproved, but it is working at the moment and I am happy this end!!!

    <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>

    Jerry
    Jerry

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Creating Worksheet Templates-A success (XL97 --->)

    I'm glad it works well for you. Thanks for sharing the result with other Loungers.

Posting Permissions

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