引用不同工作簿的工作表的正确语法是什么?以下代码在最后一行抛出错误。谢谢!
'Instantiate Workbook variables
Dim mWB As Workbook 'master workbook
'Instantiate Worksheet variables
Dim mWS As Worksheet 'master worksheet
'Open Workbook, set variables and reference range
Workbooks.Open ("Local 500GB HD:Users:user:Public:file.xlsx")
Set mWB = ActiveWorkbook
Set mWS = Sheets("Invoices")
mWB.mWS.Range("A1").FormulaR1C1 = "Import Date" ' <---- This is the where the error is
Change
Set mWS = Sheets("Invoices")
To
Set mWS = mWb.Sheets("Invoices")
然后就写mWS.Range("A1").FormulaR1C1 = "Import Date"
在最后一行。
实际上,您只需将最后一行更改为我上面放置的那样,因为您的ActiveWorkbook
并没有改变,但是,最佳实践是准确限定所有变量,这样就不会发生意外行为。
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系:hwhale#tublm.com(使用前将#替换为@)