+ Reply to Thread
Results 1 to 6 of 6

Is it possible to create Picture Links Dynamically using VBA..

  1. #1
    Registered User
    Join Date
    11-03-2008
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    2,385

    Is it possible to create Picture Links Dynamically using VBA..

    Is it possible to create Picture Links Dynamically using VBA..

    Dear Forum,

    I need to use the wonderful feature of a Picture Link where the Data is updates as and when the Source Data changes and this is quite a useful feature especially between different Sheets or even DIfferent WorkBooks if possible..

    But Anyways, what I want is to do this entire procedure through VBA..Certain Data to be Pciture Linked would be a Matrix 10 Rows X 5 Columns and some would be 6 Rows X 5 Columns. so instead of doing it manually each time, will it be possible to get this done through VBA and also display it at a suitable position from the Target Cell in the other sheet.

    Warm Regards
    e4excel
    Last edited by e4excel; 09-30-2011 at 02:16 AM.

  2. #2
    Registered User
    Join Date
    11-03-2008
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    2,385

    Re: Is it possible to create Picture Links Dynamically using VBA..

    USeful Links:

    http://excel-user.blogspot.com/2010/...mera-tool.html

    http://www.techrepublic.com/blog/mso...xcel-data/1438

    But these are to get the Camera Icon !

  3. #3
    Registered User
    Join Date
    11-03-2008
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    2,385

    Re: Is it possible to create Picture Links Dynamically using VBA..

    Well, while googling for this feature I found something which might be useful but am not able to completely decipher the same...


    Link :
    http://www.experts-exchange.com/Soft...mera-Tool.html

    VBA CODE:

    Please Login or Register  to view this content.
    My Range is going to Expand or Contract and therefore the Picture Link needs to update itself Automatically..

    CAn someone please help me based on this code or something better too..!

    I think I got the part of expanding based on the info given in the link however this code goes into an error..

    Please Login or Register  to view this content.

    And everytime A new Picture n is created...

    Regards
    e4excel
    Attached Files Attached Files
    Last edited by e4excel; 09-30-2011 at 05:00 AM.

  4. #4
    Registered User
    Join Date
    11-03-2008
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    2,385

    Re: Is it possible to create Picture Links Dynamically using VBA..

    In my actual file the Date to be Picture Linked is of fixed nO of Columns but Fluctuating Rows and I want this at a particular Position on the screen...

    As the Source Data is going to be in the Sheet 2 and it needs to shown as Picture Link in the Sheet1 then I want it to be at the same row on the selected data in the Sheet 1.

  5. #5
    Registered User
    Join Date
    11-03-2008
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    2,385

    Re: Is it possible to create Picture Links Dynamically using VBA..

    Dear Forum,

    Can someone with good VBA skills help me in this as its very useful for me in y work as the Picture link is going to be used between 2 different sheets

  6. #6
    Registered User
    Join Date
    11-03-2008
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    2,385

    Bump No Response

    Bump No Response

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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