Convert xlsx file to HTML with VBscript or batch script

Question

I've researched for days but I can not find anything to resolve this issue that I am having.

I have an excel file in .xlsx format that is updated through out the day. What I need to do is call a batch that converts it to .html. I will be taking that HTML file and copying it to a folder that automatically publishes it for internal uses at my company.

If anyone out there can help it would be greatly appreciated.

Bond · Accepted Answer · 2014-07-07 14:40:29Z

5

Excel lets you save as a web page natively. It also has a "single file" web page that combines all images/etc into a single file. It uses the mht or mhtml extension.

Const xlHtml = 44
Const xlWebArchive = 45

' Create an instance of Excel and open the workbook...
Set objExcel = CreateObject("Excel.Application")
objExcel.Workbooks.Open "C:\Folder\MyWorkbook.xlsx"

' Save the workbook as an HTML or MHTML page...
objExcel.ActiveWorkbook.SaveAs "C:\Folder\MyPage.html",  xlHtml
' -or-
objExcel.ActiveWorkbook.SaveAs "C:\Folder\MyPage.mhtml", xlWebArchive

' Close Excel...
objExcel.Quit

answered Jul 7, 2014 at 14:40

Bond

16.3k6 gold badges34 silver badges56 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

BetterWithFetter Over a year ago

So trying to implement this into something production related at work and we are seeing the folder that this also creates with the stylesheet.css file and everything else the HTML file calls. Is there a way for just a straight HTML file that doesn't need all of the other stuff?

Bond Over a year ago

Did you try using the xlWebArchive type with the mht or mhtml extension like I showed?

sPS · Accepted Answer · 2017-07-20 09:51:49Z

2

If Some one looking for C#

Add Reference -> COM -> Look for Microsoft Excel, Microsoft Office then

using Excel = Microsoft.Office.Interop.Excel;

namespace ExcelToSinglePageWeb
{
    class Program
    {
        static void Main(string[] args)
        {
            Excel.Application xlApp = new Excel.Application();
            Excel.Workbook xlWorkbook = xlApp.Workbooks.Open(@"C:\Users\name\Desktop\Work In Progress.xlsx");
            xlWorkbook.SaveAs(@"C:\Users\name\Desktop\SomePage.mhtml", 45);
            xlApp.Quit();
        }
    }
}

answered Jul 20, 2017 at 9:51

sPS

738 bronze badges

Collectives™ on Stack Overflow

Convert xlsx file to HTML with VBscript or batch script

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related