Locating the directory a workbook is stored in

[Graham Whitehead]

Hi, I was just wondering if it possible to get excel to return the location
of the workbook that is currently in use. If so does anyone know the VBA
code to do this? Thanks.

[Bharath Rajamani]

try this -->

Dim wsh1 as Worksheet
Dim sPath as String

Set wsh1 = ActiveWorkbook.Worksheets(1)
sPath = ActiveWorkbook.Path & "\"


Rgds,

"Graham Whitehead" wrote:

> Hi, I was just wondering if it possible to get excel to return the location
> of the workbook that is currently in use. If so does anyone know the VBA
> code to do this? Thanks.
>
>
>