Easy way to Convert Excel into HTML

How to Convert Excel into HTML

1) Copy the Macro from this link http://dmcritchie.mvps.org/excel/code/xl2htmlx.txt

2) Create the Macro using Microsoft Visual Basic by doing the following

3) Click the Microsoft Office Button and click Excel Options

4) In the Popular category, under Top options for working with Excel, select the Show Developer tab in the Ribbon check box, and then click OK.

5) On the Developer tab, in the Code group, click Macro Security.

6) Under Macro Settings, click Enable all macros (not recommended, potentially dangerous code can run), and then click OK.

7) On the Developer tab, in the Code group, click Visual Basic.

8) If needed, in the Visual Basic Editor, on the Insert menu, click Module.

9) In the code window of the module, type or copy the macro code that you want to use.

10) Go back to the Excel Spreadsheet and Select the part of the spreadsheet you want to convert to HTML

11) Go to the Visual Basic Editor and press F5.

12) Select the option XL2HTML

13) Choose a place to save the HTML file

Done!

Related Articles

Leave a Reply

Your email address will not be published. Required fields are marked *