Where does VBA store its code?
Can anyone tell me where to find several hundred lines of MS Word VBA code I wrote? Here is the genesis of that code. I have an Excel workbook with a database of a few thousand books that I want to contribute to some university library.
I use Excel to hold the data, first because I’m fairly familiar with that program but do not know as well any equivalent database program such as Access.
Second, I use Excel because it has more than enough power to manipulate the few thousand books now in my database. Unfortunately, Excel does not have the word processing power of Word, so I use that program for creating reports with the Excel data.
The procedure is relatively simple:
Can anyone tell me where Word stores VBA code in this situation? I hope my work is not lost.
—John Robin Allen
Foothills (near Calgary), Alberta