打开workbook
https://learn.microsoft.com/zh-cn/office/vba/api/Excel.Workbooks.Open
打开 (FileName、 UpdateLinks、 ReadOnly、 Format、 Password、 WriteResPassword、 IgnoreReadOnlyRecommended、 Origin、 Delimiter、 Editable、 Notify、 Converter、 AddToMru、 Local、 CorruptLoad)
按照顺序写参数就不需要写参数名字
Set book_test = Workbooks.open("C:\1.xlsx")
Set book_test = Workbooks.open("C:\1.xlsx",ReadOnly:=True) 只读方式打开
Set book_test = Workbooks.open("C:\1.xlsx",False) 不展示是否更新链接弹窗
Set book_test = Workbooks.open("C:\1.xlsx",False,True)
标签:xlsx,vba,Set,Workbooks,test,book,WorkBook,open From: https://www.cnblogs.com/shizunatsu/p/17252993.html