+ Reply to Thread
Results 1 to 3 of 3

Copy from first workbook, close open new workbook paste close

  1. #1
    Registered User
    Join Date
    08-22-2014
    Location
    south africa
    MS-Off Ver
    2007
    Posts
    0

    Copy from first workbook, close open new workbook paste close

    i would like to select a copy range from active workbook and sheet from "A2" to last populated cell in column "G"
    then close this workbook. open a new workbook "workbook2" sheet "sheet1" and paste to first unpopulated row, save and close workbook

  2. #2
    Registered User
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,164
    Hello johncarr1952,

    Welcome to Excelforum. Be a part of large Excel community. Enjoy Learning.
    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]

  3. #3
    Registered User
    Join Date
    05-12-2021
    Location
    Europe
    MS-Off Ver
    365
    Posts
    44

    Re: Copy from first workbook, close open new workbook paste close

    Try this:
    Please Login or Register  to view this content.
    I also atached an example file with this code
    Attached Files Attached Files

+ 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] Open Multiple Workbooks, Record names, Copy paste to Active Workbook, Close the Workbooks
    By vba_madness in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 01-24-2013, 06:09 AM
  2. Replies: 13
    Last Post: 11-29-2012, 08:25 PM
  3. Replies: 2
    Last Post: 09-11-2012, 09:42 AM
  4. Workbook open, copy and close - Help
    By momossy in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-17-2010, 08:36 AM
  5. Close other workbook after Copy/Paste?
    By proepert in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-26-2010, 01:59 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