Public Var1 As String, Var2 As String, Var3 As String, Var4 As String, Var5 As String, Var6 As String, Var7 As String, Var8 As String, link As String Dim appExcel As Object Dim wbExcel As Object Dim wsExcel As Object Dim Rang As Object Dim numero As Integer Public celltrouv As Variant Dim heure As String Dim PauseTime, Start Dim Looping As Boolean 'déclaration pour mettre dans la barre des taches Option Explicit Private Const SW_HIDE = 0 Private Const SW_SHOW = 5 Private Declare Function ShowWindow Lib "user32" _ (ByVal hWnd As Long, ByVal nCmdShow As Long) As Long Private Const GWL_EXSTYLE = (-20) Private Const WS_EX_APPWINDOW = &H40000 Private Declare Function GetWindowLong Lib "user32" _ Alias "GetWindowLongA" _ (ByVal hWnd As Long, ByVal nIndex As Long) As Long Private Declare Function SetWindowLong Lib "user32" _ Alias "SetWindowLongA" _ (ByVal hWnd As Long, ByVal nIndex As Long, _ ByVal dwNewLong As Long) As Long Public Sub Command1_Click() Looping = True Do While Looping heure = Now List1.Clear List2.Clear List3.Clear List4.Clear List5.Clear List6.Clear List7.Clear List8.Clear Label2.Caption = "" Label3.Caption = "" Set appExcel = CreateObject("Excel.Application") Set wbExcel = appExcel.Workbooks.open("d:\TEMP\Classeur01.xls", ReadOnly:=True) Set wsExcel = wbExcel.ActiveSheet wbExcel.RefreshAll Var4 = wbExcel.Sheets(2).Range("M1").Value Label2.Caption = Var4 & " Changements en cours" Label3.Caption = heure If Var4 = "" Then Label2.Caption = "Pas de changement en cours" End If Set Rang = wbExcel.Sheets(2).Range("L2:L1200") numero = 1 For Each celltrouv In Rang If celltrouv = numero Then Var1 = celltrouv.Offset(0, -2).Value & " -- " & "Responsable : " & celltrouv.Offset(0, -6).Value & " -- " & "Description : " & celltrouv.Offset(0, -7).Value & vbCrLf Var6 = celltrouv.Offset(0, 2).Value If Var6 Like "*MVS*" Then Me.List1.AddItem Var1 End If If Var6 Like "*AIX*" Then Me.List2.AddItem Var1 End If If Var6 Like "*LINUX*" Then Me.List3.AddItem Var1 End If If Var6 Like "*RESEAU*" Then Me.List4.AddItem Var1 End If If Var6 Like "*WINDOWS*" Then Me.List5.AddItem Var1 End If If Var6 Like "*HPUX*" Then Me.List6.AddItem Var1 End If If Var6 Like "*BULL*" Then Me.List7.AddItem Var1 End If If Var6 Like "*POSTPROD*" Then Me.List8.AddItem Var1 End If If Var6 Like "*NETWARE*" Then Me.List8.AddItem Var1 End If End If DoEvents Next celltrouv wbExcel.Close SaveChanges:=False appExcel.Quit Set Rang = Nothing Set wsExcel = Nothing Set wbExcel = Nothing Set appExcel = Nothing PauseTime = 30 ' Définit la durée. Start = Timer ' Définit l'heure de début. Do While Timer < Start + PauseTime DoEvents Loop Loop End Sub Private Sub Command2_Click() Looping = False End Sub Private Sub Command3_Click() End End Sub Private Sub Form_Load() Text1.Visible = False ' Il faut que BorderStyle = 0 ' - None ' Mais quand même une caption pour qu'elle apparaisse ' dans la barre des tâches Me.Caption = "SPYDT" End Sub Private Sub Form_Activate() Dim ExStyle As Long, lResult As Long lResult = ShowWindow(Me.hWnd, SW_HIDE) ExStyle = GetWindowLong(Me.hWnd, GWL_EXSTYLE) lResult = SetWindowLong(Me.hWnd, GWL_EXSTYLE, _ ExStyle Or WS_EX_APPWINDOW) lResult = ShowWindow(Me.hWnd, SW_SHOW) End Sub Private Sub Form_Click() Me.WindowState = vbMinimized ' Il n'y aura pas de menu système, ni sur la fenêtre ' ni sur le bouton de la barre des tâches End Sub Private Sub List1_Click() Text1.Text = List1.Text Var7 = Text1.Text Var8 = Mid(Var7, 2, 5) link = "http://BLABLA/Changements/default.asp?Changement=" & Var8 Shell "explorer.exe " & Chr(34) & link & Chr(34) DoEvents End Sub Private Sub List2_Click() Text1.Text = List2.Text Var7 = Text1.Text Var8 = Mid(Var7, 2, 5) link = "http://BLABLA/Changements/default.asp?Changement=" & Var8 Shell "explorer.exe " & Chr(34) & link & Chr(34) DoEvents End Sub Private Sub List3_Click() Text1.Text = List3.Text Var7 = Text1.Text Var8 = Mid(Var7, 2, 5) link = "http://BLABLA/Changements/default.asp?Changement=" & Var8 Shell "explorer.exe " & Chr(34) & link & Chr(34) DoEvents End Sub Private Sub List4_Click() Text1.Text = List4.Text Var7 = Text1.Text Var8 = Mid(Var7, 2, 5) link = "http://BLABLA/Changements/default.asp?Changement=" & Var8 Shell "explorer.exe " & Chr(34) & link & Chr(34) DoEvents End Sub Private Sub List5_Click() Text1.Text = List5.Text Var7 = Text1.Text Var8 = Mid(Var7, 2, 5) link = "http://BLABLA/Changements/default.asp?Changement=" & Var8 Shell "explorer.exe " & Chr(34) & link & Chr(34) DoEvents End Sub Private Sub List6_Click() Text1.Text = List6.Text Var7 = Text1.Text Var8 = Mid(Var7, 2, 5) link = "http://BLABLA/Changements/default.asp?Changement=" & Var8 Shell "explorer.exe " & Chr(34) & link & Chr(34) DoEvents End Sub Private Sub List7_Click() Text1.Text = List7.Text Var7 = Text1.Text Var8 = Mid(Var7, 2, 5) link = "http://BLABLA/Changements/default.asp?Changement=" & Var8 Shell "explorer.exe " & Chr(34) & link & Chr(34) DoEvents End Sub Private Sub List8_Click() Text1.Text = List8.Text Var7 = Text1.Text Var8 = Mid(Var7, 2, 5) link = "http://BLABLA/Changements/default.asp?Changement=" & Var8 Shell "explorer.exe " & Chr(34) & link & Chr(34) DoEvents End Sub
Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre questionPrivate Sub List1_Click() Text1.Text = List1.Text Var7 = Text1.Text Var8 = Mid(Var7, 2, 5) link = "http://BLABLA/Changements/default.asp?Changement=" & Var8 Shell "explorer.exe " & Chr(34) & link & Chr(34) DoEvents End Sub
sURL = "URL;" & "http://blablabla" & Var9 & "&opendate_to=" & Var10 & "&open_Type=2&start_Type=3&end_Type=3&saisie_Type=3&close_Type=3" 'Create the QueryTable Dim sNWind As String sNWind = _ sURL Dim oQryTable As Object Set oQryTable = wsExcel.QueryTables.Add( _ "OLEDB;Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & _ sNWind & ";", wsExcel.Range("A1"), "Select * from Orders") oQryTable.RefreshStyle = xlInsertEntireRows oQryTable.Refresh False