Sorry guys I have tried a lot of scripts from all over the internet including here and always seem to catch errors or other problems. I need to get Parts Lists from AutoCad 2008 Drawings to Excel. I attached an example of how we make parts lists to this post. Everything should be in PaperSpace and in Mtext format.

My idea of how it should work would be.
1.) run the macro from autocad
2.) select the part list
3.) export the text to Excel
4.) save the excel file as the same name as the drawing file

Sorry for asking what seems to be answered all over the internet I just cant seem to get anything to work for me.