I have Word 2003. I have a RPT file (Crystal Reports-generated, I think)
which needs to be imported and formatted. It is in "space-delimited" format,
with a layout like this:
************************************************************
Comp Date Warr# AMT ACCOUNT DESCRIPTION
XYZ 1/2/2004 22614105 195.36 TOOLS & EQUIP UNDER $1000
190.08 TOOLS & EQUIP UNDER
$1000
190.08 TOOLS & EQUIP
UNDER $1000
95.04 REPAIR & MNTNCE
SUPPLIES
179.52 TOOLS & EQUIP
UNDER $1000
************************************************************
It is "space-delimited," meaning that rather than having commas or tab stops
between each field/column, it's a bunch of spaces.
The tricks:
(1) It needs to be imported into Word, formatted to look like that
(2) It needs to end up in as "plain" a format as possible--not in table
format, rich text etc
(3) It's okay if "XYZ" and date etc information doesn't repeat when it
doesn't change
(4) The biggie--a macro (in Visual Basic I assume) needs to do all that with
the click of a button
I am able to write Visual Basic all day long in Access, and I can do simple
ones in Word--but funky ones like this in Word, it's beyond me.
Where are some websites which can explain how? Anyone have any ideas
themselves?
LRH
macropod - 10 Mar 2004 08:01 GMT
OK, so why not simply copy into word and format the data as Courier New?
Can't get much simpler than that.
Cheers
> I have Word 2003. I have a RPT file (Crystal Reports-generated, I think)
> which needs to be imported and formatted. It is in "space-delimited" format,
[quoted text clipped - 34 lines]
>
> LRH