我有这个代码从excel中的其他已关闭的工作簿中复制数据 .
Sub CopyData()
Dim DTLBranchValue As Variant
Application.ScreenUpdating = False
Application.Calculation = xlCalculationManual
DTLBranchValue = "D:\Adryan Work\Project Sales Progress\DTL_SI_BRANCH_VALUE_crosstab.xlsx"
GetData DTLBranchValue, "DTL_SI_BRANCH_VALUE_crosstab", "C4:JO93", Sheets("Detail Value All Brand").Range("C19:JO108"), False, False
Application.Calculation = xlCalculationAutomatic
Application.ScreenUpdating = True
End Sub
我用技术在这里做How to copy data from closed workbooks(keeping them closed) into master workbook using VBA
它只能从其他具有“.xlsx”格式的工作簿中复制 . 如果我想从“.CSV文件”复制，我需要打开该工作簿，以便代码可以运行 . 如何在不打开该工作簿的情况下从“.CSV”文件进行复制？