Identify Full Path of Opened Excel Workbook

[monir]

In a VBA Excel macro, how can I identify the full path of "this" opened
workbook test1.xls, and then use it to open another file test2.xls at the
same location ?

Will the procedure change the current folder in the File menu ?

Thank you.

[Bob Phillips]

Activeworkbook.Path

--

HTH

RP
(remove nothere from the email address if mailing direct)


"monir" <monir@discussions.microsoft.com> wrote in message
news:E3F453B6-DD62-4C5D-B859-2EA36CB6C1C9@microsoft.com...
> In a VBA Excel macro, how can I identify the full path of "this" opened
> workbook test1.xls, and then use it to open another file test2.xls at the
> same location ?
>
> Will the procedure change the current folder in the File menu ?
>
> Thank you.

[Dana DeLouis]

Here's one of a few ways:

Sub Demo()
Dim v
Dim WbToOpen
Dim ps As String

ps = Application.PathSeparator

v = Split(ThisWorkbook.FullName, ps)
v(UBound(v)) = "Test2.xls"
WbToOpen = Join(v, ps)
' etc...
End Sub

HTH
--
Dana DeLouis
Win XP & Office 2003


"monir" <monir@discussions.microsoft.com> wrote in message
news:E3F453B6-DD62-4C5D-B859-2EA36CB6C1C9@microsoft.com...
> In a VBA Excel macro, how can I identify the full path of "this" opened
> workbook test1.xls, and then use it to open another file test2.xls at the
> same location ?
>
> Will the procedure change the current folder in the File menu ?
>
> Thank you.

[Tim Williams]

workbooks.open thisworkbook.path & "\test2.xls"

Tim


"monir" <monir@discussions.microsoft.com> wrote in message
news:E3F453B6-DD62-4C5D-B859-2EA36CB6C1C9@microsoft.com...
> In a VBA Excel macro, how can I identify the full path of "this"
> opened
> workbook test1.xls, and then use it to open another file test2.xls
> at the
> same location ?
>
> Will the procedure change the current folder in the File menu ?
>
> Thank you.

[Tom Ogilvy]

sPath = Activeworkbook.Path

--
Regards,
Tom Ogilvy

"monir" <monir@discussions.microsoft.com> wrote in message
news:E3F453B6-DD62-4C5D-B859-2EA36CB6C1C9@microsoft.com...
> In a VBA Excel macro, how can I identify the full path of "this" opened
> workbook test1.xls, and then use it to open another file test2.xls at the
> same location ?
>
> Will the procedure change the current folder in the File menu ?
>
> Thank you.

[monir]

Bob, Dana, Tim, Tom;

Very helpful! Thank you all.