Sorting data based in word into excel

[theegg1984]

hi.

Does anyone know if there is anyway of sorting data from a word document into an excel spreadheet?

<a href="http://s72.photobucket.com/albums/i174/patburstsintoflames/?action=view&current=imageforforum.jpg" target="_blank"><img src="http://i72.photobucket.com/albums/i174/patburstsintoflames/imageforforum.jpg" border="0" alt="Photobucket"></a>

I want to sort be able to export the data according to the column on the far left hand side (month), into excel.


ideally i would have liked to have all the data in excel as it would make things easier but in this instance i need to keep all the data input in word.

Is there anything i can do?

 

[VoG]

I think that's a question for a new thread. But try a search of the board first.

 

[theegg1984]

ok - i've started a new thread, thanks a lot!

 

[mack5511]

I am using the last version of the code and it works great except for one issue. On my most important table of data in word when it copies to excel it does not bring the first column. Some tables it works fine on but the larger tables it misses the copy past to excel.

ie


Word table has the following:

Col A Col B Col C
1234 John Smith


In excel I get


Col A Col B Col C
Blank John Smith




The column headers are fine just no following data. Let me know if you have any suggestions.

Thanks,

Mack