Email:      Pass:    Pass?
Close Window   
Free Ebook
Get Your Free Excel
ebook!
Our Top 15 Excel Tutorials
Instant Access!
E-mail:
Subscribe for Free Excel tips & more!
E-mail:
Advertisements



How To Extract Image Source Urls From Work Sheet?

Forum Register
Search Excel Forum Posts, Tutorials, Macros, Tips, and More

Hi

Using Excel 2007

I am in the process of converting a static html website to an access database driven site.
Most pages are made up of tables containing text, hyperlinks and small thumbnail images.

I found that I can just copy and paste from the HTML into Excel and I found a macro code on the web to extract the hyperlink url.

But I am having difficulty extracting the image (thumbnail) source url.

I know very little about macro's, can anyone advise what macro code might do the job for me?

Many thanks

Happy.

View Answers     

Similar Excel Tutorials

Set a Photo/Image as an Excel Worksheet Background
One of the really cool formatting features of Excel is that you can actually set a picture from your computer as t ...
Add Image Background to a Chart in Excel
How to use an image for the background of a chart in Excel. Simple but fun way to spruce up charts. Click the desi ...
Open PDF from Excel
How to open a PDF file from a clickable button, link, or image in Excel.  This allows you to seamlessly link PDF f ...
Combine Data from Multiple Worksheets in Excel
The easiest way to combine and consolidate data in Excel. Simple method to combine data from multiple worksheets i ...

Helpful Excel Macros

Add Background Photos / Images to Comments in Excel
- Add background images and photos to your comments in Excel with this macro. This macro uses a really cool feature in Ex
Basic Web Query in Excel - Import Data from the Web into Excel
- Import data from the web into Excel with this macro. This is a basic web query macro that will import data from any web
Excel Macro that Searches Entire Workbook and Returns All Matches
- This is the ultimate Lookup Macro for Excel. It will search every worksheet in the workbook and return all of the mat
Get Values from a Chart
- This macro will pull the values from a chart in excel and list those values on another spreadsheet. This will get the s
Remove (Delete) Hyperlinks from Worksheets
- This macro will remove all hyperlinks from the active worksheet. It will delete the hyperlinks but it will not delete t

Similar Topics









I have a simple request (I think...)

I have a list of url's in column A.
Columns B, C, D, E, F - is where I'll be looking to fill with extracted data.

I need a macro that will go through each URL from column A , and then look through the HTML Source View and I want to extract certain html code.
For example I want to extract anything between an <H1>H1 tags</H1>.

My task requires me to just go to a website, and copy and paste the values that are in the same spot.
So I'll have to copy the title tags and some extra text found in the very same spots.

There are more than 300 urls and this is going to be a waste of my time.

I'll need to be able to easily modify the variables in case I need to extract something else.

VBA/Macro solutions welcome (even formulas if possible)

I would appreciate this alot !

Thank You

One more question and I'll have this project completely finished!

Is there a way to extract the image location url from a group of pasted images?
Meaning:
Copy any section of images and text from a website such a category page from a shop.
Paste it into excel. The images all have links (to the corresponding product).

By searching I found functions to extract the link url from all pictures pasted onto a tab.
However I haven't been able to find a way to extract the image location url itself. Any suggestions?

This may seem like an odd question, but I'm creating a tool to generate all the html for a newseltter for a client. She struggles with html so I essentially making her a form to fill out, then she can copy & paste all the generated html at once and be done.


Hi Excel gurus,

I am in a bit of dilema, i've been racking my brains and cant come up with a solution

here's the story: i'm currently running a macro that inserts image URL's into comments on an excel spreadhseet, theres rows upon rows of image urls and when you hover over the image url cell you'll get an image appear, is it at all possible to insert the images alongside the image URL on that corresponding row?? so for example row A1 would be www.imageurl.com/image.jpg and in cell A2 would be a small thumbsized version of the image (doesnt matter if the comment is included or not) i simply need a thumbnail to be inserted beside the image urls

is that at all possible?!?!

thank you




Hi

I am in desperate need of help Please.
I am using Excel for Mac 2011 and have downloaded an .xls file from my supplier's website.
The first column is meant to contain a thumbnail of an image for each product in the list, but after downloading the file, each image shows a big red cross and states "The linked image cannot be displayed".
I don't necessarily need the image to display but I do need to extract the URL from each image and place it in another column.

I can do this one at a time by right clicking the image file and then selecting "Format Picture". Under "Alt Text" the URL is shown as the "Description".
I take it that the images are not hyperlinked otherwise the URL would be displayed under "Hyperlink" too when right clicking an image?
Due to the fact that there are literally hundreds of products on each downloaded list with multiple variations of each I cannot do this one at a time and need to be able to extract this url information ALLOT quicker.

Is there a function in excel or a macro I can create to allow me to do this?

I have attached a file for reference.

xlsmarchioNuwt.xl.xls

Thanks!
Alan



Hi

I am in desperate need of help Please.
I am using Excel for Mac 2011 and have downloaded an .xls file from my supplier's website.
The first column is meant to contain a thumbnail of an image for each product in the list, but after downloading the file, each image shows a big red cross and states "The linked image cannot be displayed".
I don't necessarily need the image to display but I do need to extract the URL from each image and place it in another column.

I can do this one at a time by right clicking the image file and then selecting "Format Picture". Under "Alt Text" the URL is shown as the "Description".
I take it that the images are not hyperlinked otherwise the URL would be displayed under "Hyperlink" too when right clicking an image?
Due to the fact that there are literally hundreds of products on each downloaded list with multiple variations of each I cannot do this one at a time and need to be able to extract this url information ALLOT quicker.

Is there a function in excel or a macro I can create to allow me to do this?

I have attached a file for reference.

xlsmarchioNuwt.xl.xls

Thanks!
Alan

Hi there,

I have a few things i am doing to a worksheet and need a little guidance regarding the possibilities and a bit of help making it happen.

in my worksheet, the first column of every cell (Starting from A21, A22, A23 and so on) i will be inserting a small thumbnail picture apprx size is 1.03cm x 1.23cm (Quite Small). What i would like to achieve is when you click on that picture or double click it enlarges the image to 4.76cm x 5.48cm ( a decent viewable thumbnail image).

My plan once i can get this and another issue i am working on resolved. the worksheet will be converted to a interactive PDF so these images can be clicked to increase size and clicked again to go back to small thumbnail.

I have read another post about this stating "connect the object to a macro that "loads" or hyperlinks to the actual full sized object when clicked on"

But really have no idea how to do this or where to start.

I did find the following whilst search the net for answers but have no clue about VBA
http://www.mrexcel.com/forum/showthread.php?t=406370

I am using open office (calc) so do not know if i can use Visual Basic and have tried the whole ATL+F11 thing
Cozzienz


I need to build excel sheets and be able to convert images to text. I copy the sheet from a web site and all fields in the table come in as text except for one. That field can be 1 of two images. Right now i have to save the xl sheet as html and then Find/Replace the html image code with a + or - sign which is time consuming. Is there a way I can convert he image though excel. I need to be able to sort the sheet as well as pull the data into a separate tab.


I need to build excel sheets and be able to convert images to text. I copy the sheet from a web site and all fields in the table come in as text except for one. That field can be 1 of two images. Right now i have to save the xl sheet as html and then Find/Replace the html image code with a + or - sign which is time consuming and difficult to outsource. Is there a way I can convert the image through excel. I need to be able to sort the sheet as well as pull the data into a separate tab.


Is there anyway to insert an image into excel so that when you roll over certain text a thumbnail will pop up? Similar to how the address pops up when you mouse over a hyperlink..
This would be a huge plus and would really help me out. Does anyone know how to do this or a workaround for the next best thing?
Thanks!


I am in deperate need of help.

I have a spreadshee where a column contains web URLS. I need a macro that will search through the urls and find urls from a particualr site and extract information from the url

i.e.
all the urls from a given web site look like this
http://curiouscanuck.iscapenetwork.c...x.html&ID=1614

I need to extract the http://www.edunetconnect.com/cat/rebellions/index.html part that lies between the "url=" and the "&ID"

I am a little familiar with programming and understand ltrim and rtrim but have never worked in excel b4


I am creating an online storefront for an art studio and have a supplier that has allowed me to use their content online. ie their product descriptions and images. I am able to import all the relevant information regarding the products into an excel database, however when it comes to linking the images, I am coming up short.

The catalog I am building has approx 10,000 products, each with an image. These images are already hosted on a site which I have permission to use, how can I select the image urls I want to use and import them into the database, instead of right clicking on each image and pasting them into my database?

Please help, I'm getting frustrated...

For a reference point, My supplier's website is www.silverleadco.com


I am trying to get some urls from this webpage http://rivals.yahoo.com/ncaa/basketb...d?d=2011-02-20. I record a macro to dump all tables into excel but the urls i am looking for "boxscore" only show as a text and not as a link. But in the page source, the url is displayed. so is there a way for excel to get only the page source?


Hello All,

You folks have helped me out immensely in the past. Not a new Excel user here, but really stumped on this one.

I have a fairly elaborate invoicing sheet I made for my business of printing backstage passes, credentials, etc.

On the customer proof copy, I'd like to be able to have thumbnail size images of the product(s) they are ordering (the credential, the type of lanyard, etc.)

So, I made a separate sheet in the workbook that has those small images in each cell. The cell is big enough to hold the image without any "spillover".

vlookup works fine for everything else text-wise, but I was wondering how I could (or even if it is possible) to have it return an image as a result.

If it isn't possible through vlookup, is it possible to do another way without having to go crazy with VB programming?

Thanks to anyone who can help...

Mike


Hi,
I have copied and pasted a big table to excel. All the images have links and I need to extract that URL and post on it's own cell.
I have tried some hyperlink extracting code but I realized the images are not necessarily in a cell.

Is there a way to do this?

and by the way, is the a way to make the images show? I know they are there but they don't show.

I appreciate your help.

Thanks


How does Excel handle image filenames when an image is inserted "from file"? Does Excel store the file name anywhere?

I have inserted a large amount of thumbnail images that are low resolution into a worksheet to keep the file size small. My goal is to write a macro that will turn each of these thumbnails into a link to the full resolution image. I compressed the photos before inserting them into excel. I used the same file name, just saved the image thumbnails in a different folder. I am working with around 20,000 images in my file, so manually doing so is completely out of the question.


hi - i have a whole bunch of thumbnail sized images in an excel sheet that are placed there by a third party application (so if they are saved on my hard drive, i do not know the path).

i would like to have some way to click or mouse over them and enlarge them for viewing.

i considered creating a user form to copy and view the image or just writing some VBA to resize the image when it is selected and putting it back when deselected.

I'm guessing someone has done this before, but i haven't found quite what i am looking for in the forums. any help would be appreciated.

thanks.


I'm trying to automate a process for downloading PDF files from a website that uses unique URLs. I thought source code in each unique URL contained the data needed to find the PDF to download, but apparently it does not. So, I need to click the PDF icon and save the PDF image to my harddrive (and continue to the next one via a loop).

here's an initial site with the PDF icon: http://www.nalpdirectory.com/dledir_...09&orgtypeid=F

The source code that is related to the PDF icon is in row 112-115 (I can't paste it here because mrexcel does not recognize I am pasting as text and not HTML).

If you click on the PDF icon for the above URL, it will open up a new URL with the PDF, which is unique: http://www.nalpdirectory.com/forms/m...0899211178.pdf

I know how to capture table data from websites, but not how to follow a javascript link via a button and then download the corresponding file. Any help is appreciated. Here are additional related starting URLs:
http://www.nalpdirectory.com/dledir_...09&orgtypeid=F

http://www.nalpdirectory.com/dledir_...09&orgtypeid=F

Thanks in advance for your assistance


Hi!

Wanted to share an experience I've had with Office 2007. I created a macro that processes a folder with Excel workbooks, selecting a specific sheet in each workbook, copying a range with integrated photos and charts, and finally pasting the image into a WORD document. When using Application.ScreenUpdating=False to speed up the process, the images are never included in the final paste image. The code works when I step through it with F8, but as soon as I run the macro the images get lost. There might be an issue with .xls and .xlsx files, since it's so far only .xls files that lose images, not .xlsx files.

We've had other problems with copy/paste a range with integrated images (charts or other images inside the copied range) as image and zooming with Excel 2007.

FYI Martin




Hi there

Really struggling with this one, so any help really is greatly appreciated (I have lost hours of my day to this already).

I have used the code below a good number of times to extract the entire HTML source code of a webpage and pass it to a string in Excel VBA.



Please Login or Register  to view this content.


The problem I have is that I now need the entire HTML source code for a webpage which requires a login. The above code gets the HTML for the page which is displayed on going to the URL when I am not logged into the site - I need the source code for the same URL, but post login.

I am thinking that something involving



Please Login or Register  to view this content.


may be needed, but any thoughts are greatly appreciated. I am happy to go into Internet Explorer prior to running the code to ensure that I am logged into the site.

Many thanks

Andrew

Dear All,

We are generating some images with excel 2003 using the below code:

Sub testbmp() Selection.Copy
Range("B50").Select
ActiveSheet.Pictures.Paste(Link:=True).Select
End Sub


After that we: Scale the image to a desired size (x4) Save the file as a html, this creates a GIF file for the generated image This is working fine in most of the cases, but some cases we found that the generated image is distorted, where the text looks like bold and wider.

It can be due to a patch or the excel macro? The server that runs this macro has Standard Office 2003.

Find enclosed two examples of the problem; Good Image.gif and Bad Image.gif

Good Image:
http://img340.imageshack.us/img340/3...svalidatio.gif

Bad Image:
http://img340.imageshack.us/img340/8...sproductio.gif

It is there any way to avoid or address this issue?

Thanks in advance.


I've searched through this forum (and a ton of stuff on the net) and still have not found a way to make this happen; at least one that I can understand, at least. :P

I want to place a thumbnail image inside a cell for each row of my spreadsheet and have those images STAY in that cell. Once I get the images in the cell, they float - if I sort the rows, the images get all mixed up...

Any words o' wisdom?


I have a set up in Excel2002 a spreadsheet with numerous worksheets. In each worksheet is one column in which I have inserted an image as a thumbnail. Each of these thumbnails is hyperlinked to the original larger image and when activated this is shown in a seperate window thru Ifranview.

I have had to move the location of all the larger images and wish to edit all the hyperlinks without doing it individually. I only need to change the first part of each link
ie change c:\folder x\folder y\y.jpg to e:\folder a\folder y\y.jpg

any help would be appreciated i am quite new to this


Hi,
I have copied and pasted a big table to excel. All the images have links and I need to extract that URL and post on it's own cell.
I have tried some hyperlink extracting code but I realized the images are not necessarily in a cell.

Is there a way to do this?

and by the way, is the a way to make the images show? I know they are there but they don't show.

I appreciate your help.

Thanks


I have a client who sends me a listing of their branch offices' hyperlinks for processing, but they are always in text. Maybe they are coming in from a database or something, I really don't know. The list is in perfect vertical order on the Excel spreadsheets, but each link is not "hot", only text. I know that I can hi-light each one, hit the spacebar and Exel converts it into a hot hyperlink, but this is becoming seriously tedious. I searched the forum and found this, which seems to be close to my problem:
http://www.excelforum.com/excel-gene...lain-text.html

The problem is that I know nothing about macros so I don't understand the explanation. I am picturing, maybe, hi-lighting the entire page list, and using a "miracle" key combination to convert the whole thing into hyperlinks at one crack. Or something. Can anyone step me through setting up a page so that I can easily convert these lists of text URLs into hyperlinked URLs?


Hi,

I am trying to download attachments/thumbnails from a website using a macro. Please see a part of my code below. I am able to reach up to an image but not able to download the file and save it at a particular location on my pc .

Also the loop takes a while to reach to the thumbnails on the webpage. Is there a way to improve the speed of the code ?
Thanks,

MG.

Code:

      ...
    Set objIE = CreateObject("InternetExplorer.Application")
     
    With objIE
        .Navigate "http://www.trade2win.com/boards/technical-analysis/65170-fastma-zero-lag-moving-average.html" 
        .Visible = 1
        Do While .Busy: DoEvents: Loop
            Do While .readyState  4: DoEvents: Loop
                 
                Set htmlDoc = .document
                Set htmlColl = htmlDoc.getElementsByTagName("IMG")
                 
                For Each htmlInput In htmlColl
               
  If htmlInput.className = "thumbnail" Then htmlInput.Click                                    

                Next htmlInput
                
               ...