Resolved: Application Path in VBA

[volcanoz]

How do we find the Application path or the path from which a VBA code is getting executed? Is there anything similar to App.Path (available in VB) command in VBA?

[RobDog888]

Welcome to the Forums.

Your soooo close :D
'Excel
Application.Path
'And for VBA
ThisWorkbook.Path

[volcanoz]

Thanks Rob. But am using VBA thats available as a Customization tool for Ms Great Plains.

While i was discussing with my friend drpcken on this, we stumbled upon the solution. CurDir seems to satisfy our requirement.

Thanks Rob and Thanks Kenny(drpcken)

[drpcken]

Hey Congrats Vol.

Be sure to edit your original post and make the icon the GREEN CHECK and add [RESOLVED] in your Title. This lets us know that the issue is no longer a problem and helps someoene else whomight have this problem

[volcanoz]

This was my first post. Thanks for updating me on the procedure i will follow this from my next post.

volcanoz

[RobDog888]

Oh, ok. What I gave you is valid for all Office suite programs that have VBA support.

Watch out for CurDir since that can be changed. I dont have great plains
setup but we will help where we can. :thumb: