|
[广告] Excel易用宝 - 提升Excel的操作效率 · Excel / WPS表格插件 ★ 免费下载 ★ ★ 使用帮助★
If Len(Month(Date)) = 1 And Len(Day(Date)) = 1 Then
x = Right(Year(Date), 2) & "0" & Month(Date) & "0" & Day(Date)
ElseIf Len(Month(Date)) = 1 And Len(Day(Date)) = 2 Then
x = Right(Year(Date), 2) & "0" & Month(Date) & Day(Date)
ElseIf Len(Month(Date)) = 2 And Len(Day(Date)) = 1 Then
x = Right(Year(Date), 2) & Month(Date) & "0" & Day(Date)
ElseIf Len(Month(Date)) = 2 And Len(Day(Date)) = 2 Then
x = Right(Year(Date), 2) & Month(Date) & Day(Date)
End If
Application.EnableEvents = False
y = "C:\Users\Desktop\2019\abc" & x & "\.xlsx"
Set wb = GetObject(y)
提示自动化操作时文件名或类名未找到
|
|