Obtaining the application name using VBA

[LaBelette]

Hi!

I try to obtain the application name using VBA code. I know application.currentproject.name , but it gives me the 'file' name.
What I want is the title I've put in Tools> ApplicationName properties menu> General> Project name in the VBA window.
Anyone knows?

 

[modest]

I dont understand what you're asking CurrentDb.Name ?!???


Edit:
Nevermind, you want the VBA Project Name

 

[LaBelette]

Edit:
Nevermind, you want the VBA Project Name

Exactly, but what's the code to get it?

 

[modest]

I'm not sure how to display it.

But this is how you set it:
Application.VBE.VBProjects("VBAProject").Name = NewName
where NewName is a string.

Just look into the VBE

..hope this helps,
modest

 

[LaBelette]

Solution!!!

Application.VBE.ActiveVBProject.Name works perfectly!!!

Thanks for putting me on this track!!!

 

[modest]

No prob, the odd thing is that before I posted I tried
Application.VBE.ActiveVBProject.Name and it came back with an error on how I was using it..
So I just posted what I knew worked.

Take care,
modest