作者licheer (Keep The Faith)
看板Visual_Basic
标题[VBA ] 读取另一个Excel里的资料然後排列
时间Wed Sep 16 00:41:48 2015
共有两个Excel档A,B
A要去读B里面某一栏的资料,然後填在A的其中一列中
目前想到的做法是组合栏位及列的名称
感觉有点麻烦
想请教有没有比较有效率的写法..谢谢
ColIdxArr = Array("D","E","F","G","H","I","J","K","L","M","N","O")
RowIdxArr = Array("3","4","5","6","7","8","9","10","11","12","13","14")
For i = 0 To 11
Sheets("Sheet1").Range(ColIdxArr(i) + "4").Formula =
"='C:\Data\[File1.xls]Sheet2'!D" + RowIdxArr(i)
Next
--
※ 发信站: 批踢踢实业坊(ptt.cc), 来自: 61.224.85.208
※ 文章网址: https://webptt.com/cn.aspx?n=bbs/Visual_Basic/M.1442335310.A.62F.html
1F：→ MOONRAKER: 用cells(r, c)便不用拼英文字母了 09/16 08:12
2F：→ MOONRAKER: 看起来你的区域是连续的 应该可以用copy/paste 09/16 08:13