This post will explain how to export a range of data from an Excel worksheet to an HTML or web page file using the Save As command and VBA code. This method allows you to create a standalone HTML file that can be opened in any web browser, making it easy to share your data with others.
Export a Range of Data to HTML or Web Page File with Save As Command
If you want to export a range of data from Excel to HTML or web page file, one common method is to use the “Save As” function in Excel.
Here are the steps:
Step1: Select the range of data you want to export to HTML. You can select the cells by clicking and dragging the cursor over the cells.
Step2: Click on the “File” tab in the Excel ribbon. Click on “Save As“.
Step3: In the “Save As” dialog box, choose “Web Page” from the file type dropdown menu. Choose the location where you want to save the file and give it a name. Click on “Publish” button.
Step4: In the “Publish Options” section, select the “Selection” option to export only the selected range of cells. click Save button.
Step5: the Publish as Web Page dialog box will open, Click on the “Publish” button to export the range of data to an HTML file.
Step6: After completing these steps, the selected range of data will be exported to an HTML file that can be opened in a web browser.
Export a Range of Data to HTML or Web Page File with VBA Code
You can also export a range of data to an HTML file with VBA Code in Excel, and you can use the Application.InputBox function to select the range of data to export and prompt the user to select the destination directory and filename. Just do the following steps:
Step1: Press ALT + F11 on your keyboard to open the Visual Basic Editor (VBE).
Step2: In the VBE, click on the Insert menu and select Module. This will create a new module in your VBA project.
Step3: Copy the below VBA code and paste it into the module. Save your VBA project and close the VBE.
Sub ExportRangeToHTML_Excelgeek() Dim wb As Workbook Dim ws As Worksheet Dim rng As Range Dim htmlFile As String Set wb = ThisWorkbook Set ws = wb.ActiveSheet ' Prompt the user to select the range of data to export Set rng = Application.InputBox(prompt:="Select the range of data to export as HTML", Type:=8) ' Prompt the user to select the destination directory and filename htmlFile = Application.GetSaveAsFilename(fileFilter:="HTML Files (*.html), *.html") 'Create a new workbook with the selected range of data and save it as an HTML file Dim newWb As Workbook Set newWb = Workbooks.Add rng.Copy newWb.Sheets(1).Range("A1").PasteSpecial xlPasteAll newWb.SaveAs htmlFile, xlHtml newWb.Close MsgBox "Selected range has been exported to " & htmlFile End Sub
Step4: Press ALT + F8 on your keyboard to open the Macro dialog box. Select the ExportRangeToHTML_Excelgeek macro from the list and click the Run button.
Step5: select the range of data to export in your current worksheet.
Step6: choose a location to save the HTML file.
Step7: Once the macro has completed, a message box will appear indicating that the selected range has been exported to the chosen location.
You should now have an HTML file containing the data from the selected range.
Now you can quickly and easily export a range of data to an HTML file without having to manually copy and paste the data into a web page editor.