Editing a text file from VBA

Hi,

I'm looking to clear all lines in a text file from VBA, starting from the second line.

From what I've seen so far it seems like the "fso" object is the way to go, but unfortunately I haven't found anyone doing what I'm trying to do exactly.

Anyone able to help?

Thanks!

Mike

Maybe this?

Please Login or Register  to view this content.

Hi guys, thanks for the responses!

@Holger, I wasn't able to get your one to work for some reason, but @millz, yours worked perfectly.

Could you possibly explain what the code is doing?

Thanks again, both of you!

Mike

A quick summary:
- Asks for text file
- Open the selected text file
- Read the first line of text, and store it in a variable
- Create a new blank text file with the same directory\file name. Original file is overwritten
- Writes that stored variable (first line of text) in the newly created text file

@millz, great, thanks so much!