Hi All,
I need a macro which copies the table content from word(2013) to Excel (2013). For example say, my word tables are as follows:
<tbody>
</tbody>
<tbody>
</tbody>
The output excel should be as follows:
<tbody>
</tbody>
This macro should loop through all the tables in my word document and copy the tables to excel in the above mentioned manner. Appreciate your help here. Thanks.
I need a macro which copies the table content from word(2013) to Excel (2013). For example say, my word tables are as follows:
Item | Electrical |
Name | Power chord |
Number | 3249 |
Order No | 1-2998734 |
Sending detail | 1. Dispatched from local facility 2. Dispatched from remote facility |
Expected Delivery | 1. Initially 3 days 2. Currently 1 day |
<tbody>
</tbody>
Item | Non-Electrical |
Name | Wood block |
Number | 3250 |
Order No | 1-2998735 |
Sending detail | 1. Dispatched from facility1 2. Dispatched from facility2 3. Dispatched from facility2 |
Expected Delivery | 1. Initially 5 days 2. Currently 2 day |
<tbody>
</tbody>
The output excel should be as follows:
Item | Name | Number | Order No | Sending Detail | Expected delivery |
Electrical | Power chord | 3249 | 1-2998734 | Dispatched from local facility | Initially 3 days |
Dispatched from remote facility | Currently 1 day | ||||
Non-Electrical | Wood block | 3250 | 1-2998735 | Dispatched from facility1 | Initially 5 days |
Dispatched from facility2 | Currently 2 day | ||||
Dispatched from facility3 |
<tbody>
</tbody>
This macro should loop through all the tables in my word document and copy the tables to excel in the above mentioned manner. Appreciate your help here. Thanks.