+ Reply to Thread
Results 1 to 4 of 4

Macro to open wokbook and copy and Paste Data

  1. #1
    Forum Contributor
    Join Date
    07-12-2018
    Location
    South Africa
    MS-Off Ver
    Office 2021
    Posts
    2,709

    Macro to open wokbook and copy and Paste Data

    I have tried to write code to open a workbook and copy data from Sheet "Comm" from cell A5 to the last row in Col E and paste this on Sheet "Data" on the active workbook



    I get a run time error


    I have attached the source workbook (Comm deals) as well as the destination workbook (Import Deals)




    It would be appreciated if someone could kindly assist me


    Please Login or Register  to view this content.
    Attached Files Attached Files

  2. #2
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,122

    Re: Macro to open wokbook and copy and Paste Data

    Please Login or Register  to view this content.
    Good Luck
    I don't presume to know what I am doing, however, just like you, I too started somewhere...
    One-day, One-problem at a time!!!
    If you feel I have helped, please click on the star to left of post [Add Reputation]
    Also....add a comment if you like!!!!
    And remember...Mark Thread as Solved.
    Excel Forum Rocks!!!

  3. #3
    Forum Contributor
    Join Date
    06-20-2012
    Location
    India
    MS-Off Ver
    Office 365
    Posts
    359

    Re: Macro to open wokbook and copy and Paste Data

    Try your code Modified little bit

    Please Login or Register  to view this content.

  4. #4
    Forum Contributor
    Join Date
    07-12-2018
    Location
    South Africa
    MS-Off Ver
    Office 2021
    Posts
    2,709

    Re: Macro to open wokbook and copy and Paste Data

    Thanks for the help guys. Code works perfectly

+ 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. Open All Excel Files in Folder and Copy and Paste Data in Macro-Running Workbook
    By dhfinancex in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-24-2017, 01:48 PM
  2. VBA: open workbook, find values, paste into next available cell in other wokbook
    By SAE.01 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-15-2015, 12:51 PM
  3. Macro to copy data, open new workbook and paste data there
    By bazofio in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-26-2015, 11:46 AM
  4. [SOLVED] help with data from a second wokbook in the open workbook
    By jmac1947 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 04-09-2014, 06:18 AM
  5. [SOLVED] Need help! Macro to open sequentially named files, copy and paste data into a master file
    By derrickk in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 06-05-2013, 03:35 PM
  6. Replies: 0
    Last Post: 05-08-2013, 02:47 PM
  7. Open Separate File, Copy Data and Paste Macro
    By boohah in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-31-2010, 02:04 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