Question

我想宣读一个半殖民地(;)在一份有宏观帮助的Excsv文件中的有限文件(Visual Basic)。

I don t need all data from the *.csv file; I only need three defined columns of it. These three columns should be imported in defined columns of the target Excel sheet.

任何建议?

Answer 1

这项任务有两个步骤:

Loop through all .csv files in your file http://www.ozgrid.com/VBA/loop-through.htm

在每个工作手册中采用所有电子表格

Dim ws as Worksheet
Set ws = wb.Worksheets(1)   Set wb = Workbooks.Open( Your files ) in step 1
  Copy columns here

Finished

友情链接