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.
