|
Sub M5305_report()
Dim M5305 As Workbook
Dim Exchange As String
Dim TT As String
Dim Report As Workbook
Dim AL010 As String
Dim AL010Name As String
Dim Namee As String
Dim Endrow As Long
Dim weeks As Long
Set M5305 = ThisWorkbook
Application.ScreenUpdating = False
Application.DisplayAlerts = False
Namee = Format(Date, "yyyy-mm-dd")
M5305.Sheets(1).Cells(1, 1).Value = "=ROUNDUP(TODAY()/7,0)-ROUND(DATE(YEAR(TODAY()),1,1)/7,0)"
weeks = M5305.Sheets(1).Cells(1, 1).Value - 1
Exchange = "\\Retcn466-nt0001.ikea.com\exchange\"
AL010 = "\\RETCN466-NT0001.ikea.com\Common\Supply Support\01 Daily report\Auto gadd\"
TT = Dir(Exchange & "\id_5305_*.xls")
If TT = "" Then
Application.Quit
End If
AL010Name = "range " & Namee & ".xls"
Workbooks.Open Filename:=Exchange & TT (走到这里就走不动了)
Cells.Copy M5305.Sheets(1).Range("A1")
Workbooks(TT).Close
M5305.Activate
Sheets(1).Activate
|
|