I have many .csv files that need to be imported into excel, they are all in the same format with different number name of file.
I'd like to export a select column from a certain file by just enter the file number
For example:
2438.csv contains:[TABLE="width: 500"]
<tbody>[TR]
[TD]Time[/TD]
[TD]Step[/TD]
[TD]Analog 2[/TD]
[TD]Analog 3[/TD]
[TD]Analog 4[/TD]
[/TR]
[TR]
[TD]4:12:51[/TD]
[TD]1[/TD]
[TD]5[/TD]
[TD]7[/TD]
[TD]6[/TD]
[/TR]
[TR]
[TD]4:15:51[/TD]
[TD]2[/TD]
[TD]7[/TD]
[TD]8[/TD]
[TD]9[/TD]
[/TR]
</tbody>[/TABLE]
I would want to import csv file 2438, 2439, 2440 of column 3 (Analog 2) of all the step 2
Some results like
[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD]2438[/TD]
[TD]2439[/TD]
[TD]2440[/TD]
[/TR]
[TR]
[TD]Time[/TD]
[TD]Step[/TD]
[TD]Analog 1[/TD]
[TD]Analog 2[/TD]
[TD]Analog 3[/TD]
[/TR]
</tbody>[/TABLE]
Is there a way that I just need to change the number of the file in excel and macros will just import of that file?
Thanks
I'd like to export a select column from a certain file by just enter the file number
For example:
2438.csv contains:[TABLE="width: 500"]
<tbody>[TR]
[TD]Time[/TD]
[TD]Step[/TD]
[TD]Analog 2[/TD]
[TD]Analog 3[/TD]
[TD]Analog 4[/TD]
[/TR]
[TR]
[TD]4:12:51[/TD]
[TD]1[/TD]
[TD]5[/TD]
[TD]7[/TD]
[TD]6[/TD]
[/TR]
[TR]
[TD]4:15:51[/TD]
[TD]2[/TD]
[TD]7[/TD]
[TD]8[/TD]
[TD]9[/TD]
[/TR]
</tbody>[/TABLE]
I would want to import csv file 2438, 2439, 2440 of column 3 (Analog 2) of all the step 2
Some results like
[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD]2438[/TD]
[TD]2439[/TD]
[TD]2440[/TD]
[/TR]
[TR]
[TD]Time[/TD]
[TD]Step[/TD]
[TD]Analog 1[/TD]
[TD]Analog 2[/TD]
[TD]Analog 3[/TD]
[/TR]
</tbody>[/TABLE]
Is there a way that I just need to change the number of the file in excel and macros will just import of that file?
Thanks