Results 1 to 3 of 3

Thread: Merge spreadsheets from 2 files into new workbook

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. 12-05-2013, 03:12 PM #3
    MrBlackd
    MrBlackd is offline
    Member
    Join Date
    Jul 2013
    Posts
    40
    Rep Power
    0
    Code:
    'rename worksheet
NewBook.Worksheets(NewBook.Worksheets.Count).Name = xy
    My proposed solution that I had found online and shared gets stuck in the row posted.

    Any ideas why????



    Anybody??
    Last edited by MrBlackd; 12-06-2013 at 06:17 PM.
    Keep in mind all vba I know has been googled...
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Similar Threads

  1. Merge Workbooks to Master Workbook
    By donb1337 in forum Excel Help
    Replies: 6
    Last Post: 09-26-2013, 09:16 PM
  2. Merge Two Spreadsheets In To One Sheet Based On Matching Column
    By exceltoohard in forum Excel Help
    Replies: 10
    Last Post: 09-04-2013, 08:30 AM
  3. VBA To Merge Multiple Workbooks In To Single File With One Sheet Per Workbook
    By evandewater@altalang.com in forum Excel Help
    Replies: 4
    Last Post: 06-18-2013, 01:38 PM
  4. Split Workbook In To Multiple Files Using Advanced Filter And Unique Values
    By rajasekhar in forum Excel Help
    Replies: 2
    Last Post: 04-14-2013, 09:15 PM
  5. Get Name List of All Open Workbook Files
    By princ_wns in forum Excel Help
    Replies: 5
    Last Post: 04-07-2012, 12:18 PM

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
  •  

Forum Rules