Resolved: Application Path in VBA

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?

Welcome to the Forums.

Your soooo close :D

VB Code:

'Excel
Application.Path
'And for VBA
ThisWorkbook.Path

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)

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

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

volcanoz

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: