Import and Export Text data

[yanks6rule]

Hello All, I have a text file that contains 17 lines of header
information and then a bunch of data from rows 18 on. I need to import
the data to remove one column and the re-export the data as a text
file, I can do all of this manually but I wanted to try and automate
the process as it takes up way to much of my time to do this everyday
with all the data.

Here is my ultimate goal:

1-Import the text file and save the header information to attach to
the text document that is exported.

2- Delete column E after importing the raw data starting at row 18

3-Put the header information back on top of the data and export as a
text (tab delimited) file.

If anyone wants I can email the text file it is too big to post here.

Thanks,
Bob

 

[dlw]

if it's the exact same steps every time you can record a macro

 

[Shane Devenshire]

Hi,

I'm not sure of all the steps you are doing or where, but you might try
recording your actions and see how far that takes you.