HELP Import data from attached HTML file to excel

Hi All,

I am working on outlook 2010 I frequently receive emails in .HTML attachment for report purpose. The subject was different for every email. i.e. (Job UN-BOOKED VENDOR PAYMENT, Step 1) etc..

My question is, can excel import data from attached .HTML and save to particular file.

I try to upload .html file, but system doesn’t approve to attach.

If any help require please revert.

Thanks in advance

Amar K

Just open the file with Excel then re-save it

Thanks KYLE

Thanks for your prompt reply. Right now I am using copy and paste option to do this. It is easy for me and saving time from open html and save it again in excel.

As I am receiving daily 20 + files, that’s why I am asking any trick to do this as easiest way.

Thanks again for your valuable reply.

Place all html files into the same folder along with the workbook containing the following macro. [NOTE: the macro and files to import MUST BE in the same folder!!]

Will import all the html files 1 file per sheet.

Unfortunately I cannot remember where I got this code so I cannot credit the writer.

Please Login or Register  to view this content.

Thanks so much ANRICHARDS

Thanks for your valuable reply,

As per your instruction I saved file in one folder with new micro enabled excel. After running code I got error. i.e. Run-time error 13: type mismatch

f = Dir(Cells(1, 2) & "*.html")

Amar,

Did you Dim f As String or something else?

Hi Anrichards,

Regret for delay reply.

As I am not friendly with VB codes, I don’t change any word in your code. I just copied, paste it and run.

I communicate the error to you i.e. Dir(Cells(1, 2) & "*.html") , which was written in your code

Kindly lets me know, If any other process to convey error message

Thanks for your reply and kindly godliness.

Regards

Amar K