+ Reply to Thread
Results 1 to 1 of 1

Coppy links and shapes from one wb to another

  1. #1
    Forum Contributor
    Join Date
    03-08-2018
    Location
    Denmark
    MS-Off Ver
    2016 for Windows
    Posts
    413

    Coppy links and shapes from one wb to another

    Hi All

    I have a application I use at work for calculating Construction work. It containes small tables as you can se on the Picture.
    Sometimes we are 2 or 3 that work on the project, like: Capenter on WB1, Bricklayer on WB2 and painter on WB3.
    I can import the tables from a other WB, but I am a bit stuck on the best way to get the links Shapes and then get them placed the right place.
    The links and Shapes are placed in Column A and are named with the cell.adress of the cell in column B.
    The link is for Documents or pictures or drawings.

    I have uploaded a sample WB if you would take a look.
    Make a copy of the WB and save it as Source WB then close it. Then open Target WB and press THIS ONE, (Button)
    Select the Source WB in the filedialog. This will loop trough each table in SorceSheet (SourceWB) and copy them to TargetSheet (TargetWB)

    I would like to get the Shape And LINK copied and keep its place when pasted in TargetSheet.

    If you run into any Password it is 123.



    I hope some one can help me on this as I hope to get it ready for monday
    Attached Images Attached Images
    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. excel 2013 customize context shapes and shapes group menu right click
    By Giuseppe77 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-03-2016, 11:50 AM
  2. excel 2013 customize context shapes and shapes group menu right click
    By Giuseppe77 in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 12-03-2016, 11:50 AM
  3. coppy 2 collums into one ignoring blanks
    By luis6777 in forum Excel Formulas & Functions
    Replies: 21
    Last Post: 01-01-2015, 03:37 AM
  4. disable coppy and past
    By sad212 in forum Excel General
    Replies: 4
    Last Post: 05-26-2012, 09:43 AM
  5. How To Move Shapes From Another Shapes? (floating shapes)
    By MarcLev in forum Word Programming / VBA / Macros
    Replies: 2
    Last Post: 10-04-2009, 04:04 PM
  6. Coppy an undefined number of cells from one sheet to another
    By goatcheesesalad in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-29-2008, 06:29 AM
  7. [SOLVED] Macro to coppy cells to certain rows depending on value in cell
    By Esrei in forum Excel General
    Replies: 0
    Last Post: 12-09-2005, 04:00 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