I am writing (and continually updating) a rather large application using Excel and VBA. I recently added some code and I can no longer save the file. The program does what I want if I don't try to save it. Once I attempt a save, Excel locks up and terminates without a successful save. I am using Excel 2000. I see that many things have been expanded with later version of Excel but would like to stay with what I have. I have tried to save this file on two different computers without success. I ran into this before but was able to trim my code so that it would compile. I was not very space conscious when writing this code and I am sure I can reduce things but am not sure what is the best way to track things throughout the program.
I am looking for a couple of things.
1. Is there any type of a cross-reference file producing program short of writing one myself in VB or something like that? I want to look at where variables are used in the program hopefully by line number - this would be like an old days COBOL (and other) compile listing. I have saved the VBA Code as a text file so that I can manipulate it in most any way necessary.
2. I am using an external Excel form as part of the application. Can I write VBA Code in this workbook as well? And if so, how do I reference code that is placed there?