get current filepath in excel vba

i've got a macro that refernces other files. rather than hard code the
filepath for the folder the excel file is in, is there a way to determine
the current filepath? it's just that i have different users who have
different shortcuts to the folder and don't want to hard code.

cheers in advance
Matthew

The path of an open workbook?

msgbox activeworkbook.path 'the activeworkbook
msgbox thisworkbook.path 'the workbook with the code

msgbox curdir 'the current directory (when you hit File|open)

matt wrote:
>
> i've got a macro that refernces other files. rather than hard code the
> filepath for the folder the excel file is in, is there a way to determine
> the current filepath? it's just that i have different users who have
> different shortcuts to the folder and don't want to hard code.
>
> cheers in advance
> Matthew

--

Dave Peterson

One way:

Dim sPath As String
sPath = ThisWorkbook.Path

In article <4416d2df$1_1@glkas0286.greenlnk.net>,
"matt" <matthew hallam> wrote:

> i've got a macro that refernces other files. rather than hard code the
> filepath for the folder the excel file is in, is there a way to determine
> the current filepath? it's just that i have different users who have
> different shortcuts to the folder and don't want to hard code.
>
> cheers in advance
> Matthew

does this help?
Sub whatisfilepath()
MsgBox ActiveWorkbook.Path
End Sub

--
Don Guillett
SalesAid Software
dguillett1@austin.rr.com
"matt" <matthew hallam> wrote in message
news:4416d2df$1_1@glkas0286.greenlnk.net...
> i've got a macro that refernces other files. rather than hard code the
> filepath for the folder the excel file is in, is there a way to determine
> the current filepath? it's just that i have different users who have
> different shortcuts to the folder and don't want to hard code.
>
> cheers in advance
> Matthew
>

thanks, is now sorted
Matthew

"matt" <matthew hallam> wrote in message
news:4416d2df$1_1@glkas0286.greenlnk.net...
> i've got a macro that refernces other files. rather than hard code the
> filepath for the folder the excel file is in, is there a way to determine
> the current filepath? it's just that i have different users who have
> different shortcuts to the folder and don't want to hard code.
>
> cheers in advance
> Matthew
>