+ Reply to Thread
Results 1 to 8 of 8

Batch process multiple excel files from template, each file has different data in one cell

  1. #1
    Registered User
    Join Date
    11-10-2017
    Location
    Roc
    MS-Off Ver
    2016
    Posts
    5

    Question Batch process multiple excel files from template, each file has different data in one cell

    Hi All,

    I am trying to figure out a way to produce a large number of Excel files quickly. All files would be nearly identical except for the data in one cell (a different name, populated from a list). I am not sure how to go about this, have searched the web but haven't found my specific case yet. In the simple example below I would be looking to create 30 sheets just like this but with a different name in each, populated from a list of 30 names.

    Thank you in advance!
    Attached Files Attached Files
    Last edited by psu2fan; 11-24-2020 at 05:51 PM.

  2. #2
    Forum Expert
    Join Date
    05-29-2020
    Location
    NH USA
    MS-Off Ver
    365
    Posts
    1,909

    Re: Batch process multiple excel files from template, each file has different data in one

    Here is an approach

    Please Login or Register  to view this content.
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    11-10-2017
    Location
    Roc
    MS-Off Ver
    2016
    Posts
    5

    Re: Batch process multiple excel files from template, each file has different data in one

    Sorry for the delayed reply, this is fantastic, I think

    I'll adapt this for my file and report back

  4. #4
    Registered User
    Join Date
    11-10-2017
    Location
    Roc
    MS-Off Ver
    2016
    Posts
    5

    Re: Batch process multiple excel files from template, each file has different data in one

    I was able to adapt this to my specific file and it worked as described, thank you! I notice however that the formatting is lost using this code. Is there a way to have the code copy the file contents and formatting? My file has some shading and merged cells that I would like to retain with this process. I've attached a copy of the file we've been using with some simple shading and a merged cell added in. Can you help with code that would copy this and output copies with the unique name as before?

    Thank you in advance!!
    Dale
    Attached Files Attached Files

  5. #5
    Forum Expert
    Join Date
    10-10-2016
    Location
    Sheffield
    MS-Off Ver
    365 and rarely 2016
    Posts
    3,015

    Re: Batch process multiple excel files from template, each file has different data in one

    Please Login or Register  to view this content.
    changing slightly, does the above do what you require?

  6. #6
    Registered User
    Join Date
    11-10-2017
    Location
    Roc
    MS-Off Ver
    2016
    Posts
    5

    Re: Batch process multiple excel files from template, each file has different data in one

    Yes! I'm almost there! I am encountering a new issue where each output file produces an error (that I can click through each time) "The following features cannot be saved in macro-free workbooks: VB project"

    I don't mind, and prefer that the output files be macro-free, however this click for each file is an extra step I did not encounter before. Does it have to do with the way I entered the code or some excel setting?

    Thanks again in advance!!
    Dale

  7. #7
    Forum Expert
    Join Date
    05-29-2020
    Location
    NH USA
    MS-Off Ver
    365
    Posts
    1,909

    Re: Batch process multiple excel files from template, each file has different data in one

    Give this code a try

    Please Login or Register  to view this content.

  8. #8
    Registered User
    Join Date
    11-10-2017
    Location
    Roc
    MS-Off Ver
    2016
    Posts
    5

    Re: Batch process multiple excel files from template, each file has different data in one

    This works with just a minor edit to my file. Thank you and everyone for your help!

+ 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. Batch process CSV files delete entire row
    By brundag5 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 05-13-2020, 11:45 AM
  2. Replies: 6
    Last Post: 09-16-2019, 11:53 AM
  3. VBA code to insert data from multiple .txt files into one output file template file
    By psmith33 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-04-2015, 02:49 PM
  4. Replies: 2
    Last Post: 02-14-2014, 01:39 PM
  5. Multiple files to 1 'master' file - best process??
    By RossInk in forum Excel General
    Replies: 1
    Last Post: 12-19-2013, 12:49 PM
  6. [SOLVED] Adapt macro to batch process files
    By beng404 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-27-2012, 07:09 PM
  7. Batch file to start multiple excel files with auto_open() macro. Delay code needed
    By pierrelap@gmail.com in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 05-29-2005, 02:05 AM

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