How to get file's current directory path to a string in VBA?

W

wenkej

In my VBA I needed to get some data from another Excel
file located in the same directory with current host excel
file.How could I got the current file's path ,something
the same as "../" in UNIX?
Thanks!
 
H

Harald Staff

Sub test()
Dim sPath As String
sPath = ActiveWorkbook.Path
MsgBox sPath
End Sub
 

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

Active or current file path 9
A way of capturing the new path a file is stored in 1
vba browse button set to current directory 2
Import multiple workbooks to current workbook in specified row number 0
Retrieve File Names in Directories 4
Open file from path in cell and open from current file path 0
Wrong current directory 3
Need help using a relative path in VBA 0

Top