VBA - Path of the excel file

  • Thread starter Thread starter abc2002
  • Start date Start date
A

abc2002

Hi all!

Fisrt of all, I want to thank you for your support :)

My question is: How can I get the path of the current Excel file in
VBA?

thanks
 
Sub CurrDir()
Dim MyPath As String
MyPath = CurDir
MsgBox MyPath
End Sub

HTH
Jason
Atlanta, GA
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Print Files from Query Results 0
Need help using a relative path in VBA 0
How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
Trouble Installing Excel VBA Code Cleaner into Office 365 0
Excel VBA - counting cells by colors and names to it in two different rows. 0
Pivot Chart - Excel 2013 - Rotating Second and Third Lines of text onthe Horizontal Axis 0
List ConnectionString of linked, external Excel file 2
'Cannot insert object' message when I try to put a button on a worksheet 7

Back
Top