I need a macro!!!

how can I write a macro either in Excell 2000 or VB to do the following work for me:
 XXXXXX will change to XXXX, BB, XX
AAAAAA  will change to AAAA BB AA
 I mean that I have a very big file that has about two thousand lines and each line has six characters (letters and
numbers only).
 I need tochange them inthis way:
 First the first four characters then a camma then BB then
 camma then the last two charachters of the same line.
 this must be done more than 2000 times !!!!
 and some times I need to do it just in half an hour !!!
 I must say that the original file is text file, but can be opened
 with Excell, word, ....
thanks in advance.
Ren_khaAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

mlmccCommented:
Is this always the same changes?
You could do it by hand for 1 line while recording a macro.
Does Search and replace not work?

mlmcc
nigelbeCommented:
is it a normal text (.TXT) file?

Dirk HaestProject managerCommented:
Just replace your old and new filename in the open-statement

sub ChangeFile
Dim fh, fh2 As Integer
Dim line As String
fh = FreeFile
fh2 = fh + 1
Open "c:\test.txt" For Input As #fh
Open "c:\test3.txt" For Random As #fh2

Do While Not EOF(fh)
  Line Input #fh, line
  line = Left(line, 4) & ", BB, " & Right(line, 2)
  Put #fh2, , line
Loop

Close fh
Close fh2
end sub
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

Ren_khaAuthor Commented:
Dear mlmcc,
 To be honest I am going to need more Macros in future. So,
 please tell me about your method to enable me to write Macros.
 Thanks.
 Reno.
Dirk HaestProject managerCommented:
Fe: in Word
Tools - Macro - record new macro.
Now you can do whatever you want. It will be recorded and so you can recall it through tools - macro - macros
Ren_khaAuthor Commented:
dear Nigelbe,
 Thanks for your attention. It is allways a text file. But I can
 open it with any thing such as Excell, Word, notepad, wordpad.
 Since, it is only lletters and numbers and cammas (,,,,,).
 hope that you can give me some more advice.
 Thanks,
 Reno.
Ren_khaAuthor Commented:
Dear Dhaest,
 many thanks for your quick replies.
 I was just going to ask my question but you kindly answered it.
 So it will work in EXCELL 2000.
 Again let me thank you.
 Yours,
 Reno.
 
Dirk HaestProject managerCommented:
Normally it should work with excell, word, .... because I didn't use any special things.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Ren_khaAuthor Commented:
Dear Dhaest,
 Many thanks for your quick action.
 I hope to have your help in future again.
 Yours,
 Reno.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Programming

From novice to tech pro — start learning today.