vba可以打開帶通配符的excel文件嗎？

Dim y為整數，m為整數

y = 10

m = 12

workbooks . open filename:= " c:\ users \ administrator \ desktop \ front office " &；y & amp“年”&；m & amp“每月和下個月的輪班時間表。xls "

也可以這樣設置。

Dim ym作為字符串

ym = " 10 65438+二月"

workbooks . open filename:= " c:\ users \ administrator \ desktop \ front office " &；ym & amp“下個月的日程草案。xls "