Beginners Access: Importing Personal Macro Workbook

[Guest]

On my desktop, whenever I open Visual Basic Editor in any Excel application,
the Personal Macro Workbook is visible under the project explorer. When I
try to find my Personal Workbook in Access VBA, it only shows the "VBA
Project" for that file only. Is there a way to create a Personal Macro
Workbook in Access?

Any push in the right direction would be very helpful.


Thank you,

Zack Andersen

 

[John Vinson]

On my desktop, whenever I open Visual Basic Editor in any Excel application,
the Personal Macro Workbook is visible under the project explorer. When I
try to find my Personal Workbook in Access VBA, it only shows the "VBA
Project" for that file only. Is there a way to create a Personal Macro
Workbook in Access?

Any push in the right direction would be very helpful.

Access "Macros" are pretty much obsolete. The analog of Excel Macros
is not an Access Macro but a Module instead. It's just jargon - Excel
Macros are VBA code; Access Modules are VBA code (very similar code at
that, just different enough to be annoying!)

So ignore the Access Macros altogether, and just use modules.

Do note that Access IS NOT A FLAWED IMPLEMENTATION OF EXCEL. It's
*different*. For one thing, the concept of a "workbook" is simply not
relevant in the Access realm.

John W. Vinson[MVP]