+ Reply to Thread
Results 1 to 2 of 2

Writing to Multiple Excel Files at once using a Form

  1. #1
    Registered User
    Join Date
    02-11-2013
    Location
    Texas
    MS-Off Ver
    Excel 2003
    Posts
    57

    Writing to Multiple Excel Files at once using a Form

    Hello - can anyone suggest a starting point to writing an application that will take user input and write to multiple excel files? I don't want to clutter this post with too much information but can definitely get more detailed as needed.

    Thanks in advance.

  2. #2
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    365
    Posts
    19,300

    Re: Writing to Multiple Excel Files at once using a Form

    What is your level of experience with VBA? I am trying to figure out if you need guidance or you need someone to do it for you.

    How will you determine which files need to be written to?

    What kind of input will the user provide? I am trying to get an idea how much you have to prompt the user for information and how much validation will have to be done on the data.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

+ 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. [SOLVED] writing multiple files from URLs, as part of a loop
    By Palooka_ in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-22-2015, 01:47 PM
  2. [SOLVED] Excel form writing filled data to another Excel file or sheet
    By G.Bregvadze in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 03-08-2014, 03:34 AM
  3. Import datas form multiple excel files to master sheet for consolidation
    By laxmananm in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 03-06-2014, 11:11 AM
  4. [SOLVED] User form in excel- need help in writing code with if/then statement
    By PANTECH in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-15-2013, 08:04 AM
  5. Replies: 0
    Last Post: 01-28-2013, 02:25 PM
  6. open multiple text files for writing
    By pcbpinoy in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-29-2011, 12:18 AM
  7. selecting values form multiple excel files into an excel worksheet
    By martha in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-27-2005, 05:17 AM

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