请教高手如何用VBA编程读取其它excel文件中某个单元格中的内容

Question

如题所述

Answer 1

sub test()
set wb=workbooks.open("D:\其它excel文档.xls")
tmp=wb.worksheets(1).[c2]
wb.close 0
msgbox tmp
end sub本回答被提问者采纳

Answer 2

workbooks.open("d:\其它excel.xls")
x=cells(1,1)