Thread: Locating the directory a workbook is stored in
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bharath Rajamani Bharath Rajamani is offline
external usenet poster
  
Posts: 41
Default 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.



Reply With QuoteReply With Quote