Solved How to get the project name?

[backcountryprogrammer]

How do I get the project name (here FooDB) as seen in the picture?

CurrentProject.Name

gives me the file name (here Database1.accdb).

Thank you.

 

[arnelgp]

use:

CurrentProject.Name

 

[xavier.batlle]

How do I get the project name (here FooDB) as seen in the picture?

CurrentProject.Name

gives me the file name (here Database1.accdb).

Thank you.

To get the VBA Project Name, you have to use:

Application.VBE.VBProjects(1).Name

 

[backcountryprogrammer]

To get the VBA Project Name, you have to use:

Application.VBE.VBProjects(1).Name

View attachment 116608

Yes, that works.

 

[Gasman]

To get the VBA Project Name, you have to use:

Application.VBE.VBProjects(1).Name

View attachment 116608

No arnel's solution will work and somewhat simpler?

 

[xavier.batlle]

No arnel's solution will work and somewhat simpler?

Look at the outputs, Arnel's solution and mine give different outputs.

 

[Gasman]

Ah, OK.
I get the same?

In fact, mine always appear to be the same?

 

[xavier.batlle]

Ah, OK.
I get the same?
View attachment 116624

In fact, mine always appear to be the same?
View attachment 116625

You can try to change the name of the VBA project from the VBE.

 

[Gasman]

I know, I just renamed it as a test, but what benefit do you get by having them different?

 

[sonic8]

what benefit do you get by having them different?

The (VBA)project name is independent of the file name, which is a huge benefit when your file name is something like "Diabetes_Backup_20241010_RestoredToRecoverLostForms_20241014.accdb"

 

[GPGeorge]

The (VBA)project name is independent of the file name, which is a huge benefit when your file name is something like "Diabetes_Backup_20241010_RestoredToRecoverLostForms_20241014.accdb"

You've been peeking at my backup drive?

 

[backcountryprogrammer]

I know, I just renamed it as a test, but what benefit do you get by having them different?

I noticed this when I was inspecting the source property of the ErrorObject. VBA sets it to the project name and not the file name. Of course you will never notice this unless you set the project name explicitly to something else than the default.