help!!! macro request
 

Ok I am a total newbie on Excel macro'ing and I hope some of you hotshots can
help.

What I am looking for is a macro which:

a) imports an ASCII file ( ; delimeted)
AND (the worse part)
b) the last 2 colloms contain a string which holds together multiple fields.
Those fields are seperated by values as #BR1# (meaning Begin Record 1) and
#VV1# (dutch Volgend Veld 1 or.. Next Field 1). The next 'record' within the
colom will start with VR1 (dutch Volgend Record or Next Record) unitl all
'records' are handled in that colom. The colom will be closed with an ER1
(End Record)

are you having fun? Cause I certainly am not; I have absolutely no clue how
to handle this. Find and replace is one thing.. but it has it's limitations.

I hope someone can come up with a nice idea how to tackle the *******,

cheers in advance,

Archie

help!!! macro request
 

On Fri, 31 Aug 2007 06:46:03 -0700, Archer
wrote:

Ok I am a total newbie on Excel macro'ing and I hope some of you hotshots can
help.

What I am looking for is a macro which:

a) imports an ASCII file ( ; delimeted)
AND (the worse part)
b) the last 2 colloms contain a string which holds together multiple fields.
Those fields are seperated by values as #BR1# (meaning Begin Record 1) and
#VV1# (dutch Volgend Veld 1 or.. Next Field 1). The next 'record' within the
colom will start with VR1 (dutch Volgend Record or Next Record) unitl all
'records' are handled in that colom. The colom will be closed with an ER1
(End Record)

are you having fun? Cause I certainly am not; I have absolutely no clue how
to handle this. Find and replace is one thing.. but it has it's limitations.

I hope someone can come up with a nice idea how to tackle the *******,

cheers in advance,

Archie

What exactly do you want to do with the last two columns?

To import the text file, you can use Data/Text to columns wizard with ";" as
the delimiter and it will parse those records into columns.
--ron

help!!! macro request
 

"Ron Rosenfeld" wrote:

On Fri, 31 Aug 2007 06:46:03 -0700, Archer
wrote:

Ok I am a total newbie on Excel macro'ing and I hope some of you hotshots can
help.

What I am looking for is a macro which:

a) imports an ASCII file ( ; delimeted)
AND (the worse part)
b) the last 2 colloms contain a string which holds together multiple fields.
Those fields are seperated by values as #BR1# (meaning Begin Record 1) and
#VV1# (dutch Volgend Veld 1 or.. Next Field 1). The next 'record' within the
colom will start with VR1 (dutch Volgend Record or Next Record) unitl all
'records' are handled in that colom. The colom will be closed with an ER1
(End Record)

are you having fun? Cause I certainly am not; I have absolutely no clue how
to handle this. Find and replace is one thing.. but it has it's limitations.

I hope someone can come up with a nice idea how to tackle the *******,

cheers in advance,

Archie

What exactly do you want to do with the last two columns?

To import the text file, you can use Data/Text to columns wizard with ";" as
the delimiter and it will parse those records into columns.
--ron


thanks for your reply,

I to use this ASCII file as an import for an eventual mailmege.I was affraid
Word was not able to handle it so I was hoping Excel could build a file
useful for a mailmerge.

I hope someone can tell I am wrong,

thx in advance,

cheers,

Archie