Function Conversione_Scheda() As String
Dim fso, fosavefile
Dim testo As String
Dim OggFile, pathfile, OggTextStream, rigaletta
Dim contariga As Long
Set fso = New Scripting.FileSystemObject
pathfile = App.Path & "\Ext\html_scheda.txt"
On Error GoTo GestErrore
Set fosavefile = fso.CreateTextFile(App.Path & "\Ext\scheda.html", True)
Set fso = CreateObject("Scripting.FileSystemObject")
Set OggFile = fso.GetFile(pathfile)
Set OggTextStream = OggFile.OpenAsTextStream(1)
testo = Me.Text2.Text
Do While Not OggTextStream.AtEndOfStream
rigaletta = OggTextStream.ReadLine
contariga = contariga + 1
If contariga Mod 2 = 0 Then
colorebg = "#FFFFFF"
rigaletta = Replace(rigaletta, "@#colsfondo", colorebg)
ElseIf contariga Mod 2 <> 0 Then
colorebg = "#CDCFDE"
rigaletta = Replace(rigaletta, "@#colsfondo", colorebg)
End If
rigaletta = Replace(rigaletta, "@#scheda@#", testo)
fosavefile.WriteLine (rigaletta & vbCrLf)
Loop
OggTextStream.Close
fosavefile.Close
Set fosavefile = Nothing
Unload Form1
Exit Function
GestErrore:
MsgBox Err.Description
End Function