Hello.
I really need some help creating a macro that allows me to open a text file, then change some information in the file and then save it as an text file.

The syntax of the text file, or atleast i would prefer it to be, is something like this:
Please Login or Register  to view this content.
What I'm trying to accomplish is that via a macro button that says "Open File", specify the file with the content above, then have Excel open the file (each line in a separate cell from top to bottom, or all in one big cell) and then really make variables of the tags <variablex> and connect those variables to cells so that when I change the information in the cell connected to <variable1> it should also change the information in the cell that contains the information from the text file.

Then via another macro button from within Excel just save the content of the cell with the new variable data into another regular text file..

I hope any of this makes any sense cause its kinda hard to explain.

Best regards
Magnus