Workbook.ReloadAs (Excel)

Reloads a workbook based on an HTML document, using the specified document encoding.

Only MsoEncoding constants that are applicable to HTML work with the ReloadAs method.

ReloadAs (Encoding)

Encoding: The encoding that is to be applied to the workbook.

ActiveWorkbook.ReloadAs Encoding:=msoEncodingEBCDICDenmarkNorway