Class Members to Spreadsheet

[RichF]

I am moving a large QB program into Excel for modification and updating. Ultimately want a way to list the line numbers for each location of every variable in the program. (Old HP Basic had a way to do this.) How do I get a listing of each variable and procedure in Module1 into the spread sheet. Once I have this, I believe I can write the code to locate each occurance in the code and assign a line number. If I have the terminology right, I want to generate a list of each member of the module1 class. I tried this, but it didn't work.

For I = 1 to 10
Cells(I,4).value = Module1.Item(I).Name
Next I

Any help would be appreciated. Thanks