I have an Excel file that consists of many rows of data. One of the columns contains data with a hyperlink. The hyperlink takes you to a site that shows either an image or some HTML. I would like the Visual Basic for Applications in Excel, automatically resolve the hyperlink and download this information to the cell...replacing the hyperlink. This would leave you with the data and the image. The file shows an example of a before and an example of after.
The rows would need to automatically resize. The Column width should fit on one page, but the printout could be substantially longer e.g. 500 pages.
Basically, I need you to download the images and put them into the sheet with the corresponding rows. Make it look pretty so I can print it to a PDF and send to a client.
Give me a quote.
23 freelancer đang chào giá trung bình $100 cho công việc này
I've offered an insanely low bid because this shouldn't take very long, it looks quite interesting, and I'm trying to get my profile started. Please give me this opportunity.