Saving Excel (html code) to KML

[NTB]

I have the html code generated in Excel and all the code needed for the KML is in the 'output' sheet. How do I save all the text in the output sheet to a KML file?

I tried the saveas to txt, and Excel doesn't save the file correctly... it adds extra " front of " and the < > tags.

I have tried this code here that produced a correct kml file, but unless all html lines are on column A, I don't know how to add a loop that would loop thru and add all the text and indent appropriately.

Please advice!

Sub SaveAsKML()
    Set filePath = "C:\MyKML.kml"
   
    Open filePath For Output As #1
    
    'Write header to file
    outputText = [output!A3] & vbNewLine & [output!A4]
    Print #1, outputText  
    Close #1
End Sub