Application Path

[Nanda1605]

Hi, i like to get my projects startup path in VBA, i.e., how to find the installed folder of an application. I got the code in VB.NET but my requirement is to get in VBA as macro My.Application.Info.DirectoryPath.ToString

Thanks, Nanda

[_Damian S_]

If you are using VBA, I assume you are using MS Access. This is how to get the path for the current database in Access: Application.CurrentProject.Path Hope this helps.

------------------------------------------- Damian - Insert snappy one-liner here.

[Tom Deketelaere]

One way of doing it is the next currentdb.name this will return the full path with the database name

[Nanda1605]

am using MS word template, and no databases are used. pls help me in this.

Thanks, Nanda

[Tom Deketelaere]

try this Dim s As String s = CurDir s = CurDir$ s = Application.Path s = ThisDocument.Path s = ActiveDocument.Path I hardly ever use word so I'm not that good at it but these seme to return serveral path's maybe one of them is what you want