Private Declare PtrSafe Function sndPlaySound32 Lib "winmm.dll" Alias "sndPlaySoundA" (ByVal lpszSoundName As String, ByVal uFlags As Long) As Long '用来调用wav文件
Sub alert_of_sound()
Dim date1 As String
Dim wb, wb1 As Workbook
Dim ws, ws1 As Worksheet
Dim fso As New FileSystemObject
i = 0
Set ws1 = ThisWorkbook.Sheets(1)
On Error GoTo alert
Shell "python " & "D:\风控柜台\初始化.pyw", vbHide
Do While True
date1 = Range("b2")
filepath = "D:\风控柜台\V8T风控终端\MonData\" & date1 & "\" & "风险监控数据" & date1 & ".xls"
filepath1 = "D:\风控柜台