Good day
I have a spreadsheet where I import data from a closed file (also spreadsheet).
The import will only work if the file is in a recognised excel format (.xls/.xlsx/.xlsm/etc), problem is that the file to be imported is a report downloaded from a webpage page and is by default in an singleSheet html format but has a .xls extension.
Is it possible to save the file as a proper .xls file in VBA before I do the import?
Any help is much appreciated.
Bookmarks