Help with a macro please

[Buns1976]

Hi Everyone,

The macro below is an HTML copy from a folder(file:///C:/Users/HOME/Dropbox/DAILY_SALES_REPORTS/DAY_END.HTML) and pasted to a worksheet(IMPORT_HTML). Works like a charm until the DAY_END.HTML file is overwritten which we do daily.

The way it was recorded is to open folder (file:///C:/Users/HOME/Dropbox/DAILY_SALES_REPORTS/DAY_END.HTML), select open with
Internet Explorer, select all, copy, close Internet Explorer and paste to cell A1 in worksheet(IMPORT_HTML).

Not sure what the issue is so any help would be greatly appreciated.

Thank you!!

Sub TEST_IMPORT()'
' TEST_IMPORT Macro
'


    ActiveSheet.PasteSpecial Format:="HTML", Link:=False, DisplayAsIcon:= _
        False

End Sub

 

[JLGWhiz]

What do you want it to do...or not do differently?

 

[Buns1976]

Hi JLGWhiz,

What I just discovered is the macro is loading what was most recently copied in A1 so I am going down the wrong path. What I need is a macro
that will open the HTML in Internet Explorer, Select ALL, Copy, Close Internet Explorer and paste it in A1 in Worksheet IMPORT_HTML.

The path to the HTML is (file:///C:/Users/HOME/Dropbox/DAILY_SALES_REPORTS/DAY_END.HTML)

I am aware that I can import it as a linked table BUT there are 30+ tables and the workbook becomes around 5 MB and is extremely slow refreshing
so looking for a copy/paste macro.

Thank you!