+ Reply to Thread
Results 1 to 3 of 3

VBA to copy table and replace in other workbook

  1. #1
    Registered User
    Join Date
    02-08-2017
    Location
    Egypt
    MS-Off Ver
    2007
    Posts
    11

    VBA to copy table and replace in other workbook

    Hi,
    I'm creating a vba to copy table from one workbook and paste in another workbook
    The target work is protected and contain macros

    Ive created some code that is copying the new table from the first workbook and disabke the macros in the other workbook and unprotect all sheets in the new workbook and select the destination range in the new workbook and clear that range , only one thing is missing which is pasting the data
    My code is:
    Please Login or Register  to view this content.
    Last edited by FDibbins; 06-19-2017 at 02:15 AM.

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: VBA to copy table and replace in other workbook

    Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

    Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

    (I have added them for you - this time )
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Registered User
    Join Date
    02-08-2017
    Location
    Egypt
    MS-Off Ver
    2007
    Posts
    11

    Re: VBA to copy table and replace in other workbook

    Ok, thank you for adding tags to my code

+ 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] VBA Copy, Find, Copy, Replace All in Workbook From 2 columns
    By polcn in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-09-2015, 11:40 AM
  2. Copy and replace worksheet from one workbook to another
    By scarlettw123 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-02-2015, 08:11 PM
  3. How to copy pivote table details and paste (replace) with values only in same sheet
    By aleanboy in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-09-2014, 01:50 PM
  4. Replies: 0
    Last Post: 05-08-2014, 11:59 AM
  5. 1.Open workbook. 2 copy data. 3 replace data. 4 save workbook.
    By Cristobalitotom in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-05-2006, 07:24 PM
  6. [SOLVED] How to copy pivot table workbook to new workbook?
    By Wendy in forum Excel - New Users/Basics
    Replies: 0
    Last Post: 05-08-2006, 07:10 PM
  7. Copy or replace sheet1 from a closed workbook
    By Steve in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-04-2006, 07:10 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