Locating the directory a workbook is stored in
 

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.

Locating the directory a workbook is stored in
 

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.