Guest User

Untitled

a guest
Apr 23rd, 2018
68
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.75 KB | None | 0 0
  1. Sub CallBots()
  2.  
  3. Const SheetID As String = "_Buttonz"
  4. Dim btnDlg As DialogSheet
  5. Dim oSHL As Object: Set oSHL = CreateObject("WScript.Shell")
  6.  
  7. Application.ScreenUpdating = False
  8. Application.EnableEvents = False
  9.  
  10.  
  11. On Error Resume Next
  12. Application.DisplayAlerts = False
  13. ActiveWorkbook.DialogSheets("Dane_Makro").Delete
  14. Application.DisplayAlerts = True
  15. Err.Clear
  16.  
  17. Set btnDlg = ActiveWorkbook.DialogSheets.Add
  18.  
  19. With btnDlg
  20. .Name = SheetID
  21. .Visible = xlSheetHidden
  22.  
  23. With .DialogFrame
  24. .Height = 70
  25. .Width = 350
  26. .Caption = "Generowanie plików do BOTÓW"
  27. End With
  28.  
  29. With .Buttons("Button 2")
  30. .BringToFront
  31. .Width = 130
  32. .Caption = "Nowe pliki wsadowe"
  33. End With
  34.  
  35. With .Buttons("Button 3")
  36. .BringToFront
  37. .Width = 130
  38. .Caption = "Konsolidacja plików wsadowych"
  39. End With
  40.  
  41. .Labels.Add 100, 50, 100, 100
  42. .Labels(1).Caption = "Jak utowrzyć pliki wsadowe do botów?"
  43.  
  44.  
  45. ''''' THIS IS A PROBLEMATIC PLACE ''''''''''''''''
  46. If .Show = True Then
  47. oSHL.PopUP "Nowe pliki wsadowe zostaną utworzone", 1, "Tworzenie plików", vbInformation
  48. Call MakeBotsNew
  49. 'MsgBox "Nowe pliki wsadowe zostaną utworzone", 64, "Nowe pliki"
  50. Else
  51. oSHL.PopUP "Pliki wsadowe zostaną skonsolidowane", 1, "Tworzenie plików", vbInformation
  52. Call MakeBotsConso
  53. 'MsgBox "Pliki wsadowe zostaną skonsolidowane", 64, "Konsolidacja plików"
  54. End If
  55.  
  56.  
  57. 'If .CloseMode = vbFormControlMenu Then
  58. ' Exit Sub
  59. ' End If
  60. ''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
  61.  
  62. Application.DisplayAlerts = False
  63. .Delete
  64. Application.DisplayAlerts = True
  65.  
  66. End With
  67.  
  68. Application.ScreenUpdating = True
  69. Application.EnableEvents = True
  70. End Sub
Add Comment
Please, Sign In to add comment