export image and content from html file into excel via vba

dellzy

Board Regular
Joined
Apr 24, 2013
Messages
146
Hello there Excel Experts,

I have this html file that has a table consists of 3 rows and 1 column. for each row of each column, there is an image with text descriptions. What I need to do is to be able to export out as an excel file, where the output should be that the image will be attached in the first column, while the text descriptions should be in the second column. Previously I found one vba macros contributed in the internet that only be able to export the text content only but left the images. I wonder if Excel can do for both?

Thanks in advance.
DZ
 

Excel Facts

Remove leading & trailing spaces
Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().
Hello

Is the file saved on your computer? Can you post a link to it or email it to me? Or is it a web page? Can you post the address?
I would like to work with the real thing if possible.
What Excel version are you using? Note that Excel can directly open HTML files.
 
Upvote 0

Forum statistics

Threads
1,223,893
Messages
6,175,248
Members
452,623
Latest member
cliftonhandyman

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top