Importing ASCII file

[clc3]

Here is the code I have that works great, If I create my ASCII file using only the correct variables in the correct order

Please Login or Register  to view this content.

However, what I would like to know is if there is a way to import only selected column from the ASCII file....? For example lets say the ASCII would have data in 15 columns (A:O) is there I way I can reference some cells or a user form to only take the data from columns 1,3,6,8, and 13 (or whatever ones I specify) and have only those columns come in just like the above macro?

[Pete_UK]

Why don't you import all the columns, and then delete the ones you don't want at the end of the macro?

Hope this helps.

Pete

[clc3]

I am not importing into a new sheet, I need this data to come into the worksheet in the same place every time because I have formulas that reference these columns to find average rates, pressures, densities, elapsed times etc... The problem is the raw file often has more data than I need and is out of order so have to go back into my job monitoring program and re-export the data in the order I need it in and I was hoping to be able to avoid that.

BUT, I guess I could rewrite the macro to import it into a new sheet and then search for specific rows to copy and paste into my current template then delete the new sheet....