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

Incorporating the User Profile location into a document template path 1
I have lost 6 months work, how can i get my file back 1
How can I get a Shareable URL via VBA code to a OneDrive image? 0
Autonumber field in Excel that behaves the same as Access 0
OLE link 0
New computer, how do i move outlook 365 ENTIRELY? 0
Active or current file path 9
Adding data to MS Access from csv file 0

Top