Class Members to Spreadsheet

RichF

New Member
Joined
Dec 14, 2005
Messages
1
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
 

Some videos you may like

Excel Facts

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.

Watch MrExcel Video

Forum statistics

Threads
1,119,002
Messages
5,575,499
Members
412,670
Latest member
Khin Zaw Htwe
Top