If I download an html page and save it, I can open it in excel. If I then save it as an Excel file, I can read the table values into an Access table.
I need VBA to
Open the html file e.g. SACA.html from C:\SAQA_info\ using EXCEL (via Access) and then save it as C:\SAQA_info\SACA.xlsx
and close it.
Will you help please?