+ Reply to Thread
Results 1 to 2 of 2

VBA create link to ole object

  1. #1
    Registered User
    Join Date
    09-21-2020
    Location
    Frankfurt, Germany
    MS-Off Ver
    2016
    Posts
    1

    VBA create link to ole object

    Hello,

    I created a table and each column has an embedded word file (ole object). Now I want to copy the content of the table to another worksheet, so that all the cells have the values of the origin table. But for the ole object cells, I don't want to copy the word files to new ole objects, I want to create a hyperlink or icon in the specific cells that refer to the ole objects in my origin table.
    That means that when I click on this hyperlink or icon, the ole object of my origin table will open.
    For the duplicate of the table I used the ".copy" and "paste" function, but I don't know how to handle the problem with the ole files.

    Maybe someone can help me with this issue.

    Thanks,
    David

  2. #2
    Banned User!
    Join Date
    02-06-2020
    Location
    Iowa City, IA, USA
    MS-Off Ver
    2016 - 365 / 2007
    Posts
    2,014

    Re: VBA create link to ole object

    David,

    I am not an expert in the interface of excel, as I've said many times. but no one has responded to you, so. You can do all sorts of linking in excel, and I would assume you could do something like what you want to do, as well. however, the question is really the links you want to make can actually OPEN the embedded objects. because by default, you need to double click the embeds to open them, right? personally, this is all I can off you at the moment:

    https://www.google.com/search?q=exce...object+to+cell

    maybe someone else knows more.

+ 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: 0
    Last Post: 06-19-2014, 02:09 PM
  2. In Procedure: When use Actual Range Object vs Create Local Object Using Set
    By Filibuster in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 07-20-2012, 02:21 PM
  3. [SOLVED] Excel 2007 : Link macro to a cell (rather than an object)
    By maz67 in forum Excel General
    Replies: 2
    Last Post: 06-07-2012, 04:18 PM
  4. Link to Embedded Object (OLE)
    By Chaosphere in forum Excel General
    Replies: 3
    Last Post: 09-28-2011, 03:23 PM
  5. Replies: 2
    Last Post: 07-26-2010, 06:59 AM
  6. "RunTime error 429 ActiveX Object Cannot Create Object"
    By walid66 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-19-2006, 06:12 PM
  7. Link To Embedded Object
    By Brainfire in forum Excel General
    Replies: 0
    Last Post: 06-21-2006, 09:45 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