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

Copy formula down without changing references
If you have =SUM(F2:F49) in F50; type Alt+' in F51 to copy =SUM(F2:F49) to F51, leaving the formula in edit mode. Change SUM to COUNT.
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,214,527
Messages
6,120,057
Members
448,940
Latest member
mdusw

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