The amount of reformatting that can be expected is proportional to the complexity of the structure and formatting of the source document. $[officename] cannot run Visual Basic Scripts, but can load them for you to analyse. Tools - Options - Load/Save - VBA Properties
で機能を有効に設定しておけば、Excel Visual Basic スクリプトを実行することもできます。