CODEWITHSUNDEEP
vbams-accessmodule
mctldpro
mctldpro

Reputation: 21

Hard Drive Location of Access VBA Modules

in Excel, if I want to save my modules created for use across all Excel workbooks, I have the Personal.xlsb folder located here,

C:\Users\AppData\Roaming\Microsoft\Excel\XLSTART\PERSONAL.XLSB.

I can also save the Personal.xlsb file on a network drive for safe keeping should my computer corrupt or need re-imaging.

Where oh where is the same file for Access? Does it exist or do I have to export each module? My computer was backed up by IT and all of my Access vba modules are gone for every database I have.

Thanx!

Upvotes: 2

Views: 1753

Answers (2)

Foxfire And Burns And Burns
Foxfire And Burns And Burns

Reputation: 11988

Indeed, as @stewart Ross said, there is no equivalent of the personal.xlsb file in Access. But in the VBA editor in an Access file, you can select a reference to your own "master Database". For example, my "master database" with cool and useful subs and functions is Masterdatabase.accdb and I got another database called MyNewdatabase.accdb. I open VBA editor, references, and I lookp up for my masterdatabase.accdb and mark it as a reference library, and now all code I designed in my "master database" is available in the new database.

Upvotes: 1

Stewart Ross
Stewart Ross

Reputation: 1044

There is no equivalent of the personal.xlsb file in Access. All modules are stored within the .accdb / .mdb database itself. You can export all modules and store them as text files using VBA code, as this SO answer amongst others shows:

Exporting the whole vba code from an ms access application

Upvotes: 0

Related Questions