+ Reply to Thread
Results 1 to 2 of 2

How can I create multiple files from a series of data?

  1. #1
    Registered User
    Join Date
    05-04-2015
    Location
    NH
    MS-Off Ver
    Office 365
    Posts
    28

    How can I create multiple files from a series of data?

    I am trying to figure out how to create multiple files from a series of data in Excel, given a functional area specification (i.e. ABC, XYZ, etc.)...

    • I have an Area column which contains functional areas for the objects (i.e. ABC, XYZ)
    • I have an Object column which contains the object name (i.e. objectAlpha).
    • I have a Field column which contains a field name belonging to an object (i.e. field1).

    I would like to create a .txt file named after the object name with a 'template' of data. For example:

    File name: objectAlpha.txt
    File contents:
    @startuml
    object objectAlpha {
    field1
    field2
    field4
    }
    @enduml

    I have attached a sample input/output as well.
    Sample.xlsx

    Thanks!

  2. #2
    Forum Expert GeneralDisarray's Avatar
    Join Date
    09-15-2011
    Location
    Pittsburgh, PA, USA
    MS-Off Ver
    Windows Excel 2016
    Posts
    1,416

    Re: How can I create multiple files from a series of data?

    I think there is only a couple of places you need to edit this code - also, I'm using a FileSystemObject variable which means you will have to add the Microsoft Scripting Runtime to you references.

    To do that, go to the Tools menu (within the VBA environment), then go references. Find that "Microsoft Scripting Runtime" library and check the box.



    Please Login or Register  to view this content.
    Attached Files Attached Files
    Remember, saying thanks only takes a second or two. Click the star icon(*) below the post you liked, to give some Rep if you think an answer deserves it.

    Please,mark your thread [SOLVED] if you received your answer.

+ 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: 0
    Last Post: 02-19-2015, 04:04 PM
  2. How to create multiple word documents using data from multiple excel files.
    By Milan Kotus in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-14-2013, 12:07 PM
  3. Replies: 0
    Last Post: 09-18-2013, 10:13 AM
  4. How can I use VBA to create multiple pie charts from a series of data
    By johnskinner 3 in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 10-26-2012, 01:52 PM
  5. Create BubbleChart and add multiple data series
    By diskobox in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-29-2011, 12:09 PM
  6. How can I create a chart to compare multiple data series?
    By magnoliak77 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 07-01-2006, 09:10 PM
  7. [SOLVED] Create multiple data series for a chart in one shot...
    By ronbrosh111 in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 06-06-2006, 01:20 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