Re: Vba to read column of text

Hi Ben,

You could use something as simple as the following:


ActiveDocument.Tables(1).Columns(1).Select
Selection.Copy

Documents.Add
Selection.Paste


Just be sure that it's really the first table of the document and first
column of the table that you want to copy.

HTH,
Dave
"Ben" <Ben@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:CDD0A1BC-F1C4-4257-B6D3-57F69C638AFC@xxxxxxxxxxxxxxxx
> Hi,
>
> Is there a way using vba that can copy a particular column of the text
that
> i want and put into the column of the new file.
>
> For example:
> Existing colum
>
> Name Age
> Lee 23
> tan 34
> rich 34
>
>
> Copy the column of the name and paste it into new file of a new column as
> below:
>
> Name
> lee
> tan
> rich
>
>
> please advise.
>
> thanks.
>
> regards,
> ben


.

Relevant Pages