I've ended up making a text file backup of my Excel VBA work, because 95% of the time I quit Excel, the routines I've been working on (only the new ones) are gone when I relaunch Excel!
The routines are within two code modules of an addin project. One module for the "Finance" logic and another module for the "Excel programming" logic...
Basically, I'm just working on logic (email sending and generating messages from cell values.) When it is time to quit, I make sure to run the "Debug->Compile XXX" pull down menu, and then I do the "File->Close and return to Microsoft Excel" pull down menu.
Seems pretty basic... what am I missing here?
-Blakieto
Reply With Quote