VBA Code

[basavarajkh]

Hi

Can some one help me out from this problem. I am new VBA macros.

I have data like Date, ID, Last name, First name, and Middle name in the word document.

I want to convert into excel sheet with the help of VBA Marcos.


Example :-

10/12/2011

80997

Augustin

Helene

Anesthesia


10/10/2011

80621

Burgin

David

Anesthesia


Its in word Document, I need this to be come in the excel sheet as follows:-

80997 Augustin Helene Anesthesia

80621 Burgin David Anesthesia


Plz find the attached word file.


http://speedy.sh/TWzFC/ny086-update-doctor-list.doc


Plz convert it in to excel with the help of VBA Macros.

I need a help. Thank you in advance 


Regards

Basavaraj K H

 

[Hui]

Basavaraj


Have you had a look at: http://chandoo.org/wp/2011/02/17/printing-excel-reports-via-a-word-document/

 

[prasaddn]

Hi Basavaraj,


I could not open the file, but based on what I see in your problem above...


Try this

1. copy your data from word and paste in Col A from 2nd row.


2. give labels like Date, ID, LN, FN and MN in col B, C, D, E and F.


3. in cell B2 put formula =a2

in Cell C2 put formula =a3

in cell D2 put formula =a4

in cell E2 put formula =a5

in cell F2 put formula =a6


4. Drag B2:F2 till the last row of your data


5. Now the magic step, in column G, G2 cell, put formula =AND(F2<>0,F3=0)

drag the formula till the last row.

6. Filter for TRUE in Col G


Your data is ready to be copied wherever you want and paste as values


Regards,

Prasad

 

[basavarajkh]

Thank You both for Great Help

 

[basavarajkh]

Could you please help me out in the following options to have an VBA macro run with codes.


A. I have a MS.word document which is arrayed as mentioned in the attachment. I want a formula or a code wherein I can tag Ms.word document to Ms.excel with VBA coding or a formula to do this.


B. I have the same content of Ms.Word copied and pasted in to Ms.Excel, which I want to convert in from columns to rows in the following manner or set as in attachment. Could please suggest is there any VBA code as well for this or a formula.


Plz find the attached Excel File below :


http://speedy.sh/hZRXm/NY-086-update-doctors-list.xls


Plz help me.


Thanks & Regards

Basavaraj K H