How to pull the comment tags from .vb or .cs files

[satyabhaskar]

Hi,

In my project I have commented all the available funtions in a systematic way. Following is the commenting system in my project:
''' --------------------------------------------------- ''' <summary>
''' ************************************************** ******* ''' FUNCTION:
''' VAR NBR:
''' ************************************************** ******* ''' </summary>
''' <VariableName> loadApp </VariableName>
''' <VariableDiscription> loads the Application </VariableDiscription>
''' <Author> Author Name </Author>
''' <LastModifiedOn> 01/09/2012 </LastModifiedOn>
''' <LastModifiedBy> Satya </LastModifiedBy>
''' <History> 01/09/2012 - Satya - Comment</History>
''' <param name=f108RecordAreaMain></param>
''' <param name=processDate></param>
''' <param name=pcnVendorIdCd></param>
''' -------------------------------------------------
Public Function loadApp()
Return 0
End Function

Now I would like to extract the data inside these comment tags and insert into excel sheet. Can any one help me out in extracting the comments in the xml tags shown in the able format?
for example I want the value inside the <Autor> tag.

This is very urgent task for me. Can any one suggest me how to do this. I feel its good if I use macro for doing this. I dont know whether it is possible. If it is possible please let me know how to achieve that.

Thanks in Advance!

[satyabhaskar]

Hi All,

Can any one help me on the above issue.. I really urgent.

Thanks in Advance!

Regards,
Satya Bhaskar