+ Reply to Thread
Results 1 to 2 of 2

1. Promt User to Point to Location of Workbooks. 2. Combine Sheets

  1. #1
    Registered User
    Join Date
    03-23-2012
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    37

    1. Promt User to Point to Location of Workbooks. 2. Combine Sheets

    Is this possible? I know there are ways to combine all files in a folder, but this would be very useful. Here is what I would like to be able to do.

    (Call workbook containing macro book1.xlsm)

    1. User Starts Macro
    2. Promt user to give file locations
    3. Open Works
    4. Copy all cells from sheet 1 of the first location into book1.xlsm sheet 1 cell A1.
    5. Repeat 3 for second location. Copy data in column A where ever other data stops
    6. Close Workbooks
    7. Macro continues to format data as desired.

    Is there anyway to be able to vary the number of workbooks being combined? Could it ask the number of workbooks to be combine then get that many files names? Could it keep asking for file names until user tells it to combine?

  2. #2
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: 1. Promt User to Point to Location of Workbooks. 2. Combine Sheets

    This can be done. Do you have a sample file that you can upload which will show us how the location data is structured?
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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