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 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66
| '---Example pour sauver un document avec l'extention html ----
Select Case 0 '<== c.a.d. zero erreur
Case CheckObject("nimporte.quoi")
MsgBox "Non, la, tu reve!",,"test"
Case CheckObject("SAFRCFileDlg.FileSave")
With objDialog
.FileName = ""
.FileType = "Web page complete"
.OpenFileSaveDlg
SavedFile = .FileName
End With
Case CheckObject("MSComDlg.CommonDialog")
With objDialog
.DialogTitle="Save Webpage As"
.Filter="Web page complete|*.html;*.htm|All files|*.*"
.MaxFileSize = 250
.ShowSave
SavedFile = .FileName
End With
Case CheckObject("Jsdlgbox.browser")
SavedFile = objDialog.savebox
Case CheckObject("Excel.Application")
SavedFile = objDialog.GetSaveAsFilename()
Case Else
MsgBox "Aucune boite de dialogue ""Ouvrir"" ne marche sur cette foutue bécanne!",,"Erreur"
End Select
'-----Fonction a placé en bas de page si on veut----
Function CheckObject(myObj)
On Error Resume Next
Execute "Set objDialog = createobject(""" & myObj & """)"
CheckObject = Err.Number
If CheckObject = 0 Then '--- debug
MsgBox "Cette objet marche: """ & myObj & """",,"debug"
End If
Err.Clear
On Error GoTo 0
End Function
'------Vérifie la validité du nom de fichier-------
'MsgBox """" & SavedFile & """ Case: " & od,,"debug savedfile"
If SavedFile = "" Or SavedFile = False Then
MsgBox "Action canceled.",,"test"
Wscript.Quit
Else
If InStr(SavedFile, ":")>3 _
Or InStr(SavedFile, "*")>0 _
Or InStr(SavedFile, "?")>0 _
Or InStr(SavedFile, "<")>0 _
Or InStr(SavedFile, ">")>0 _
Or InStr(SavedFile, "|")>0 _
Or InStr(SavedFile, """")>0 Then
SavedFile = Replace(Replace(Replace(Replace(SavedFile, , ":",""), "*",""), "?",""), "<","")
SavedFile = Replace(Replace(Replace(Replace(SavedFile, , ">",""), "|",""), "*",""), """","")
MsgBox "Save path corrected:" & VbCrlf & SavedFile,,Title
End If
End If
If InStr(SavedFile, ".htm")=0 And InStr(SavedFile, ".html")=0 Then
If InStr(SavedFile, ".")>0 Then
SavedFile = Left(SavedFile, InStr(SavedFile, ".")-1) & ".htm"
Else
SavedFile = SavedFile & ".htm"
End If
End If
'--------Fait marcher le script dans le directory ou sera sauvé/ouvert le fichier (facultatif)--------
Set WshShell = CreateObject("WScript.Shell")
WshShell.CurrentDirectory = Left(SavedFile, InStrRev(SavedFile, "\"))
MsgBox SavedFile,,"test" |