Can I create and open an HTML file with VBA?

Question

I have a function that generates the HTML, CSS, and JS that I want. All the code is stored in a string variable.

How would I get VBA to create a .html file and open it in the default web browser?

How to create a file stackoverflow.com/questions/11503174/…. How to open an html stackoverflow.com/questions/3166265/… — Jules
– Jules, Commented Feb 24, 2016 at 0:39
HTML is just a plain text file: you can write one out using the built-in file tools in VBA or use the Scripting FileSystemObject. — Tim Williams
– Tim Williams, Commented Feb 24, 2016 at 0:59

0m3r · Accepted Answer · 2016-02-24 02:30:06Z

5

Private Declare Function ShellExecute Lib "shell32.dll" Alias "ShellExecuteA" _
     (ByVal hWnd As Long, ByVal lpOperation As String, ByVal lpFile As String, ByVal _
     lpParameters As String, ByVal lpDirectory As String, ByVal nShowCmd As Long) As Long

Sub HTML()
'   // Define your variables.
    Dim HTMLFile As String

    HTMLFile = ActiveWorkbook.Path & "\test.html"
    Close

'   // Open up the temp HTML file and format the header.
    Open HTMLFile For Output As #1
        Print #1, "<html>"
        Print #1, "<head>"
        Print #1, "<style type=""text/css"">"
        Print #1, "  body { font-size:12px;font-family:tahoma } "
        Print #1, "</style>"
        Print #1, "</head>"
        Print #1, "<body>"

        Print #1, "<h2> HELLO VBA HTML </h2>"

        Print #1, "</body>"
        Print #1, "</html>"
    Close

    ShellExecute 0&, vbNullString, HTMLFile, vbNullString, _
      vbNullString, SW_SHOWNORMAL

End Sub

answered Feb 24, 2016 at 2:30

0m3r

12.5k15 gold badges40 silver badges77 bronze badges

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

1 Comment

Mike Over a year ago

Not sure what the Private Declare Function at the top or the ShellExecute on the bottom do, but the rest of it was very helpful for creating the file. I used 'FollowHyperlink HTMLFile' to open the file.

Collectives™ on Stack Overflow

Can I create and open an HTML file with VBA?

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related