Workbooks.Open ("C:\对账单\对帐单.xlsx")
这里你可以把“C:\对账单\”换成你的绝对路径,
你可以用:a = ThisWorkbook.Path
a = ThisWorkbook.Path
Workbooks.Open ("" & a & "&" \ "&对帐单.xlsx")
Workbooks.Open ("C:\对账单\对帐单.xlsx")
这里你可以把“C:\对账单\”换成你的绝对路径,
你可以用:a = ThisWorkbook.Path
a = ThisWorkbook.Path
Workbooks.Open ("" & a & "&" \ "&对帐单.xlsx")