代码如下:Range("B1").Select ActiveCell.FormulaR1C1 = "=[标签变量集.xls]Sheet1!R7C3"我直接在"=[标签变量集.xls]Sheet1!R7C3"里添加路径"=D:\[标签变量集.xls]Sheet1!R7C3"却不能执行,求高手解答
set mybook=getobject("D:\标签变量集.xls")
Range("B1")=mybook.sheets("sheet1").cells(7,3).value
Range("B1")=mybook.sheets("sheet1").cells(7,3).value
温馨提示:答案为网友推荐,仅供参考