1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25
| Sub test20()
Dim texte As String
texte = texte & "Bonjour le forum " & vbCrLf
texte = texte & " voici une nouvelle, et plus legere, fonction dictée," & vbCrLf
texte = texte & "utilisation de, l'objet WMplayer.OCX dans un fichier vbs, externe créé dynamiquement" & vbCrLf
texte = texte & "au revoir"
create_mp3_without_Api texte, ThisWorkbook.Path & "\testenmp3.mp3"
End Sub
Sub create_mp3_without_Api(texte As String, aDestination As String)
Dim ReQ As Object, oStream As Object, URL As String
sautligne = "%2C%20": espace = "%20": virgule = "%20"
texto = Replace(Replace(Replace(texte, ",", virgule), vbCrLf, sautligne), " ", espace)
texto = Replace(Replace(texto, "éé", "eer"), "ée", "er")
URL = "https://translate.google.com/translate_tts?ie=UTF-8&tl=fr&client=t&q=" & texto & Chr(34)
On Error Resume Next 'On ne gère pas les erreurs
Set ReQ = CreateObject("Microsoft.XMLHTTP")
ReQ.Open "get", URL, False
ReQ.send
Set oStream = CreateObject("ADODB.Stream")
oStream.Open
oStream.Type = 1
oStream.Write ReQ.responseBody
oStream.SaveToFile aDestination
oStream.Close
End Sub |
Partager