Resolved: Application Path in VBA

**volcanoz** · Apr 4th, 2005, 03:57 PM

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** · Apr 4th, 2005, 04:17 PM

Welcome to the Forums.

Your soooo close

VB Code:

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

**volcanoz** · Apr 4th, 2005, 04:36 PM

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** · Apr 4th, 2005, 04:41 PM

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** · Apr 4th, 2005, 04:47 PM

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

volcanoz

**RobDog888** · Apr 4th, 2005, 04:56 PM

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.

Thread: Resolved: Application Path in VBA

Thread Tools

Display

Resolved: Application Path in VBA

Re: Application Path in VBA

Re: Application Path in VBA

Re: Application Path in VBA

Re: Resolved: Application Path in VBA

Re: Resolved: Application Path in VBA

Posting Permissions