Sub HtmlToFunction(File As String)
Dim HtmlLines() As String, TempOut As String
Dim fPath As String, fName As String, fTemp() As String
Dim i As Integer
If Len(Dir(File)) Then 'File Exists?
'Get html text...
Open File For Input As #1
HtmlLines = Split(Input(LOF(1), #1) & vbCrLf, vbCrLf) 'Split File into seperate lines...
Close
'Get Name and path of file... (Yes there are easier ways, probably using File System Objects)
fTemp = Split("\" & File, "\")
fName = fTemp(UBound(fTemp)) 'C:\path\file.html --> file.html
Path = Left(File, Len(File) - Len(fName)) 'C:\path\file.html --> C:\path\
fTemp = Split("." & File, ".")
fName = Replace(fName, ("." & fTemp(UBound(fTemp))), "") 'file.html --> file
'Create Function Header...
TempOut = "Function " & fName & "()" & vbCrLf
TempOut = TempOut & " Dim Temp As String" & vbCrLf
'Create Function Content...
For i = 0 To UBound(HtmlLines)
If Len(Trim(HtmlLines(i))) Then 'Not a blank line?
TempOut = TempOut & " Temp = Temp & """ & HtmlLines(i) & """ & vbCrLf" & vbCrLf
End If
Next
'Create Function Footer...
TempOut = TempOut & " " & fName & " = Temp" & vbCrLf
TempOut = TempOut & "End Function" & vbCrLf
'Save it to a file...
Open Path & fName & ".sub" For Output As #1
Print #1, TempOut
Close
End If
End Sub