 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Programming / March 2006Get msoLinkedPicture LinkFormat?
Hi all, I have an Excel file that contains tick and cross images that are sourced from the web, and I was wondering if there was a way to extract the URLs of the images with VB? I checked the MSDN but there doesn't seem to be a SourceName property for the object. In context I'm trying to replace the tick images with the value 1 and crosses with 0. Regards, m I can't find a way to do this with a pic inserted from file (using webadress as a filename) but if you can identify any physical differences between the pics, eg Horizontal size, you could use that to determine whether to replace with 1 or 0. Otherwise, perhaps you can query the filesize which may vary if the pics are not .BMP. Good luck. > I can't find a way to do this with a pic inserted from file (using > webadress as a filename) but if you can identify any physical [quoted text clipped - 4 lines] > > Good luck. If only there were distinguishing features between the two, not even the defined names of the Shapes help! I was quizzed about this whilst doing another IT job for a company so I hope I can find an answer, they'd be dead chuffed! Just looked at a BreakLink method for OLE objects but not sure whether this is what I'm looking for... m How are the images linked to the document? Do they still appear if there is no internet connection available? Are you able to see the information you require by manually viewing properties for the picture, eg Alternate Text? How many pictures does the doc contain, you may need to do it manually amd recommend using Wingdings font for ticks and crosses next time! I really can't work out how they're linked! The file appears to be created automatically from an .aspx document with the images in place. Without an Internet connection the pictures don't appear, but I can't find any information on the linkages at all. I exported the file to HTML and the links were there, so they must be held by Excel somewhere... The documents contain on average around 2000 images! m Perhaps rather than opening the file directly into Excel you can try importing the file as a New Web Query via Data > Import External Data? If that works you can clean up any spurious data with VBA or simply copy relevant data to a clean sheet with VBA. It would certainly be easy to analyse a particular column to retrieve parts of a URL for you ticks or crosses. That nearly worked, good suggestion but it simply just removed all image references. I ran ActiveWorkbook.LinkSources(xlOLELinks) and that says I have no LinkSources, that is totally messed up because I know they are there! I think I better get some sleep, something might come to me during the night. m |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.