Select Case Right(File1.FileName, 4) Case ".xls" Dim xlApp As Excel.Application Set xlApp = New Excel.Application xlApp.Workbooks.Open FileName:=File1.Path & "" & File1.FileName retour = MsgBox("Imprimer ce fichier ?", vbYesNo, "Imprimer") If retour = vbYes Then ThisWorkbooks.PrintOut Case ".doc" Dim WordApp As Word.Application Dim WordDoc As Word.Document Set WordApp = CreateObject("Word.Application") Set WordDoc = WordApp.Documents.Open(File1.Path & "" & File1.FileName) retour = MsgBox("Imprimer ce fichier ?", vbYesNo, "Imprimer") If retour = vbYes Then ThisDocuments.PrintOut End Select
Private Sub Cbo_TAR_Click() Select Case Me.Cbo_TAR.Text 'Selection de la liste déroulante Case "Chabal (Fonderie)" File1.Path = "C:\STAGE\CHABAL" Case "DSR (Tôlerie)" File1.Path = "C:\STAGE\DSR" Case "PF 301 (Filage)" File1.Path = "C:\STAGE\PF301" Case "F 132 (Fonderie refusion copeaux)" File1.Path = "C:\STAGE\F132" Case "F 212/219 (Atelier Tôles Fortes)" File1.Path = "C:\STAGE\F212-219" Case "F 230 (Atelier Tôles Fortes)" File1.Path = "C:\STAGE\F230" Case "F 233 (Atelier Tôles Fortes)" File1.Path = "C:\STAGE\F233" Case "F 235 (Atelier Tôles Fortes)" File1.Path = "C:\STAGE\F235" End Select End Sub Private Sub Cmd_imprimer_Click(Index As Integer) Select Case Right(File1.FileName, 4) Case ".xls" Dim xlApp As Excel.Application Set xlApp = New Excel.Application xlApp.Workbooks.Open FileName:=File1.Path & "" & File1.FileName retour = MsgBox("Imprimer ce fichier ?", vbYesNo, "Imprimer") 'fenetre de confirmation d'impression If retour = vbYes Then ThisWorkbooks.PrintOut 'si oui on imprime Case ".doc" Dim WordApp As Word.Application Dim WordDoc As Word.Document Set WordApp = CreateObject("Word.Application") Set WordDoc = WordApp.Documents.Open(File1.Path & "" & File1.FileName) retour = MsgBox("Imprimer ce fichier ?", vbYesNo, "Imprimer") 'fenetre de confirmation d'impression If retour = vbYes Then ThisDocuments.PrintOut 'si oui on imprime End Select End Sub Private Sub Cmd_modifier_Click(Index As Integer) Select Case Right(File1.FileName, 4) 'filtration de l'extention Case ".xls" 'filtration de l'extention Dim xlApp As Excel.Application Set xlApp = New Excel.Application xlApp.Visible = True 'ouverture de la fenêtre visible xlApp.Workbooks.Open FileName:=File1.Path & "" & File1.FileName 'ouverture du fichier sélectionner dans filelistbox Case ".doc" 'filtration de l'extention Dim WordApp As Word.Application Dim WordDoc As Word.Document Set WordApp = CreateObject("Word.Application") WordApp.Visible = True 'ouverture de la fenêtre visible Set WordDoc = WordApp.Documents.Open(File1.Path & "" & File1.FileName) 'ouverture du fichier sélectionner dans filelistbox End Select End Sub Private Sub Cmd_ouvrir_Click() Select Case Right(File1.FileName, 4) Case ".xls" Dim xlApp As Excel.Application Set xlApp = New Excel.Application xlApp.Visible = True xlApp.Workbooks.Open FileName:=File1.Path & "" & File1.FileName, ReadOnly:=xlYes 'ouverture en lecture seule Case ".doc" Dim WordApp As Word.Application Dim WordDoc As Word.Document Set WordApp = CreateObject("Word.Application") WordApp.Visible = True Set WordDoc = WordApp.Documents.Open(File1.Path & "" & File1.FileName, ReadOnly:=True) 'ouverture en lecture seule End Select End Sub Private Sub Form_Load() Lbl_1.Caption = "Sélectionner une tour aéroréfrigérante :" 'remplissage de la liste déroulante Cbo_TAR.AddItem "Veuillez sélectionne une TAR", 0 Cbo_TAR.AddItem "Chabal (Fonderie)", 1 Cbo_TAR.AddItem "DSR (Tôlerie)", 2 Cbo_TAR.AddItem "PF 301 (Filage)", 3 Cbo_TAR.AddItem "F 132 (Fonderie refusion copeaux)", 4 Cbo_TAR.AddItem "F 212/219 (Atelier Tôles Fortes)", 5 Cbo_TAR.AddItem "F 230 (Atelier Tôles Fortes)", 6 Cbo_TAR.AddItem "F 233 (Atelier Tôles Fortes)", 7 Cbo_TAR.AddItem "F 235 (Atelier Tôles Fortes)", 8 Cbo_TAR.ListIndex = 0 'écriture par défaut dans la liste déroulante à l'ouverture Img1.Picture = LoadPicture("C:\STAGE\plan.jpg") 'affichage du plan à l'ouverture Img2.Picture = LoadPicture("C:\STAGE\logo.jpg") 'affichage du logo à l'ouverture End Sub Private Sub Form_Resize() 'fonction pour redimmensionnement des contrôles de la fenêtre lors de l'agrandissement de celle-ci Dim Feuille As Form Set Feuille = Screen.ActiveForm If (Feuille.WindowState = vbMinimized) Then Exit Sub End If Static Longueur As Long Static Hauteur As Long Dim PropLongueur As Single Dim PropHauteur As Single If ((Longueur > 0) And (Hauteur > 0)) Then PropLongueur = Feuille.Width / Longueur PropHauteur = Feuille.Height / Hauteur Dim Ctrl As Control On Error Resume Next For Each Ctrl In Feuille.Controls Ctrl.Left = CInt(Ctrl.Left * PropLongueur) Ctrl.Top = CInt(Ctrl.Top * PropHauteur) Ctrl.Width = CInt(Ctrl.Width * PropLongueur) Ctrl.Height = CInt(Ctrl.Height * PropHauteur) Next On Error GoTo 0 End If Longueur = Feuille.Width Hauteur = Feuille.Height End Sub
Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre questionPrivate Sub Generedoc(Byval chemin as string,Byval lectureSeule as boolean,Byval Impression as boolean) ' à implémenter selon les cas... end sub
If MsgBox("Imprimer ce fichier ?", vbYesNo, "Imprimer") = vbYes Then wb.PrintOut End If
Private Sub Cmd_imprimer_Click(Index As Integer) Select Case Right(File1.FileName, 4) 'Récupère les 4 derniers caractères Case ".xls" 'Récupération de l'extension xls (fichier excel) Dim xlApp As Excel.Application Set xlApp = New Excel.Application CommonDialog.ShowPrinter xlApp.PrintOut Case ".doc" 'Récupération de l'extension doc (fichier word) Dim WordApp As Word.Application Dim WordDoc As Word.Document Set WordApp = CreateObject("Word.Application") CommonDialog.ShowPrinter WordApp.PrintOut End Select End Sub
Private Declare Function ShellExecute Lib "shell32.dll" Alias "ShellExecuteA" (ByVal hwnd As Long, _ ByVal lpOperation As String, _ ByVal lpFile As String, _ ByVal lpParameters As String, _ ByVal lpDirectory As String, _ ByVal nShowCmd As Long) As Long
ShellExecute Me.hwnd, "print", "D:\CRA" & File1.FileName, vbNullString, vbNullString, SW_SHOWNORMAL
ShellExecute Me.hwnd, "open", "D:\CRA" & File1.FileName, vbNullString, vbNullString, SW_SHOWNORMAL
ShellExecute Me.hwnd, "open", "D:\CRA" & File1.FileName, vbNullString, vbNullString, SW_SHOWNORMAL
Private Sub Cmd_imprimer_Click(Index As Integer) Select Case Right(File1.FileName, 4) 'Récupère les 4 derniers caractères Case ".xls" 'Récupération de l'extension xls (fichier excel) Dim xlApp As Excel.Application Set xlApp = New Excel.Application xlApp.Workbooks.Open FileName:=File1.Path & "" & File1.FileName CommonDialog.ShowPrinter 'Printer.hDC = CommonDialog.hDC 'Printer.Copies = CommonDialog.Copies 'Printer.Duplex = CommonDialog.Duplex 'Printer.PaperSize = CommonDialog.PaperSize 'Printer.PrintQuality = CommonDialog.PrintQuality 'Printer.Orientation = CommonDialog.Orientation 'Me.PrintForm: DoEvents 'Printer.EndDoc: DoEvents xlApp.PrintOut xlApp.Quit Case ".doc" 'Récupération de l'extension doc (fichier word) Dim WordApp As Word.Application Dim WordDoc As Word.Document Set WordApp = CreateObject("Word.Application") Set WordDoc = WordApp.Documents.Open(File1.Path & "" & File1.FileName) CommonDialog.ShowPrinter 'Printer.hDC = CommonDialog.hDC 'Printer.Copies = CommonDialog.Copies 'Printer.Duplex = CommonDialog.Duplex 'Printer.PaperSize = CommonDialog.PaperSize 'Printer.PrintQuality = CommonDialog.PrintQuality 'Printer.Orientation = CommonDialog.Orientation 'Me.PrintForm: DoEvents 'Printer.EndDoc: DoEvents WordApp.PrintOut WordApp.Quit Case ".pdf" ShellExecute Me.hwnd, "print", File1.Path & "" & File1.FileName, vbNullString, vbNullString, SW_SHOWNORMAL CommonDialog.ShowPrinter End Select End Sub