+ Reply to Thread
Results 1 to 8 of 8

Copy to other workbook

  1. #1
    Forum Contributor
    Join Date
    02-27-2015
    Location
    Norge
    MS-Off Ver
    2019
    Posts
    570

    Copy to other workbook

    Hello

    I use yhis and it work good, my question can ("EMVC Produksjonsunderlag.xlsm") be replaced with this workbook



    Please Login or Register  to view this content.
    Last edited by dodde; 12-22-2019 at 04:49 AM.

  2. #2
    Valued Forum Contributor saravnepali's Avatar
    Join Date
    01-14-2019
    Location
    Sydney Australia
    MS-Off Ver
    2010
    Posts
    447

    Re: Copy to other workbook

    It should work

    Did you tried to change code to ThisWorkbook where it says "EMVC Produksjonsunderlag.xlsm"
    If you think someone helped you, click on the "* Add Reputation" as a way to say thank you.

    If your problem is solved, go to Thread Tools and select Mark This Thread Solved

  3. #3
    Forum Contributor
    Join Date
    02-27-2015
    Location
    Norge
    MS-Off Ver
    2019
    Posts
    570

    Re: Copy to other workbook

    Hello

    Yes i dont get error but nothing copy and paste if i insert ThisWorkbook,

    Here is the whole vba

    Please Login or Register  to view this content.
    Last edited by dodde; 12-21-2019 at 07:42 PM.

  4. #4
    Valued Forum Contributor saravnepali's Avatar
    Join Date
    01-14-2019
    Location
    Sydney Australia
    MS-Off Ver
    2010
    Posts
    447

    Re: Copy to other workbook

    ON a quick look, any reason your copy from Range size is range("A2:D200") AND copy to is Range("A11:D200")

    They don't match the size

    If it doesn't work please attach the workbook itself

  5. #5
    Forum Contributor
    Join Date
    02-27-2015
    Location
    Norge
    MS-Off Ver
    2019
    Posts
    570

    Re: Copy to other workbook

    Hello

    Here is the whole wb

    Buttom Hent Data it catch data from input and open book partlist

    In module it is Kopier_partlist

    ThisWorkbook is not added in Kopier_partlist now
    Attached Files Attached Files
    Last edited by dodde; 12-21-2019 at 07:58 PM.

  6. #6
    Registered User
    Join Date
    09-01-2018
    Location
    USA
    MS-Off Ver
    365
    Posts
    96

    Re: Copy to other workbook

    try
    Please Login or Register  to view this content.

  7. #7
    Forum Contributor
    Join Date
    02-27-2015
    Location
    Norge
    MS-Off Ver
    2019
    Posts
    570

    Re: Copy to other workbook

    Hello

    Perfect this work

  8. #8
    Registered User
    Join Date
    09-01-2018
    Location
    USA
    MS-Off Ver
    365
    Posts
    96

    Re: Copy to other workbook

    You are welcome!

+ 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: 3
    Last Post: 12-07-2017, 05:14 PM
  2. Assign name to Workbook, Copy range from one workbook to another workbook
    By jakopak in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-18-2015, 03:40 AM
  3. [SOLVED] Macro to find data in source workbook and copy paste to target workbook
    By D.Lovell in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 04-23-2014, 06:21 AM
  4. Copy data one workbook to another workbook without opening workbook
    By HaroonSid in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-04-2014, 11:28 AM
  5. [SOLVED] Copy Values From Each Workbook in Folder to a Single Sheet in New Workbook +Workbook names
    By Arsham24 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-21-2012, 07:42 PM
  6. [SOLVED] copy active sheet, create new workbook, name new workbook based on cell reference
    By jm0392 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-20-2012, 07:12 PM
  7. Replies: 1
    Last Post: 04-01-2006, 03:50 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