Hi,
I have huge .out files placed in a separate folder and I want to import all the files to different columns in an excel sheet. Each .out file is having 1000 rows of records with serial numbers and values. The delimiter is space. The first two lines in the .out files are to be ignored. While importing all the .out files serial numbers are to be removed and only the values are to be pasted to a column. each records (only values) are to be pasted to a new column. I was looking for VBA codes and tried few which did not meet my requirements. Any help please. sample date is as follows from one file:
"Convergence history of Velocity Magnitude on pi1 (in SI units)"
"Iteration" "Area-Weighted Average Velocity Magnitude"
1 46.44282002092158
2 46.43021896418101
3 46.40768289527503
Regards
Prakash
I have huge .out files placed in a separate folder and I want to import all the files to different columns in an excel sheet. Each .out file is having 1000 rows of records with serial numbers and values. The delimiter is space. The first two lines in the .out files are to be ignored. While importing all the .out files serial numbers are to be removed and only the values are to be pasted to a column. each records (only values) are to be pasted to a new column. I was looking for VBA codes and tried few which did not meet my requirements. Any help please. sample date is as follows from one file:
"Convergence history of Velocity Magnitude on pi1 (in SI units)"
"Iteration" "Area-Weighted Average Velocity Magnitude"
1 46.44282002092158
2 46.43021896418101
3 46.40768289527503
Regards
Prakash
