+ Reply to Thread
Results 1 to 6 of 6

HELP Import data from attached HTML file to excel

  1. #1
    Forum Contributor
    Join Date
    07-16-2013
    Location
    India
    MS-Off Ver
    Excel 2013
    Posts
    117

    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

  2. #2
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    365 Win 11
    Posts
    7,213

    Re: HELP Import data from attached HTML file to excel

    Just open the file with Excel then re-save it

  3. #3
    Forum Contributor
    Join Date
    07-16-2013
    Location
    India
    MS-Off Ver
    Excel 2013
    Posts
    117

    Re: HELP Import data from attached HTML file to excel

    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.

  4. #4
    Forum Contributor
    Join Date
    11-04-2012
    Location
    Australia
    MS-Off Ver
    Excel 2016
    Posts
    334

    Re: HELP Import data from attached HTML file to excel

    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.

  5. #5
    Forum Contributor
    Join Date
    07-16-2013
    Location
    India
    MS-Off Ver
    Excel 2013
    Posts
    117

    Re: HELP Import data from attached HTML file to excel

    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")

  6. #6
    Forum Contributor
    Join Date
    11-04-2012
    Location
    Australia
    MS-Off Ver
    Excel 2016
    Posts
    334

    Re: HELP Import data from attached HTML file to excel

    Amar,

    Did you Dim f As String or something else?

  7. #7
    Forum Contributor
    Join Date
    07-16-2013
    Location
    India
    MS-Off Ver
    Excel 2013
    Posts
    117

    Re: HELP Import data from attached HTML file to excel

    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

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 0
    Last Post: 11-08-2012, 05:13 PM
  2. Import/pull data from html code into excel
    By emoandy05 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-13-2012, 01:39 PM
  3. [SOLVED] Match staff name and date then import data from matched row (Example attached)
    By Hyflex in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 03-26-2012, 10:33 AM
  4. [SOLVED] import data (html files)
    By Kelly******** in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-07-2006, 01:50 AM
  5. Import HTML code from a text file.
    By nathpai@walla.com in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-01-2005, 03:06 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1