+ Reply to Thread
Results 1 to 2 of 2

create copy of template file in various locations

  1. #1
    Registered User
    Join Date
    12-08-2013
    Location
    Dubai, United Arab Emirates
    MS-Off Ver
    Excel 2010
    Posts
    67

    create copy of template file in various locations

    Need some help please. Am sure I'm missing some minute details. I have a work book in which some names are fed I column A. There is a date mention in cell E2. There is a template file in a different location.

    What I'm trying to do is, for each name in column A, if the year file is not existing it should pick the template file and create a copy of in a folder location of that name.

    Following is the code in using, it's creating the folders but not the workbook, I.e the copy of the template file in all the folders.

    Please Login or Register  to view this content.
    Any help much appreciated

  2. #2
    Registered User
    Join Date
    12-08-2013
    Location
    Dubai, United Arab Emirates
    MS-Off Ver
    Excel 2010
    Posts
    67

    Re: create copy of template file in various locations

    no responses was sad to see. but thru trial and error I got around the code myself and solved it.

    am posting my code for (if) anyone interested:

    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 1
    Last Post: 12-09-2015, 06:20 PM
  2. Macro to AutoFilter create PDF/Mail and copy selected data to Template Excel file
    By iancoupal in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-07-2014, 05:47 PM
  3. Replies: 3
    Last Post: 05-15-2013, 11:34 PM
  4. Create a Template of a Worksheet to Copy
    By andrew c. in forum Excel General
    Replies: 1
    Last Post: 06-20-2011, 04:53 PM
  5. Create sequential file name for uploaded template
    By Lisa Alex in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-28-2005, 01:05 PM

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