| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Locating if a Sheet is present in a workbook | Excel Discussion (Misc queries) | |||
| Locating a Worksheet from another Workbook | Excel Worksheet Functions | |||
| Refer to picture stored in workbook | Excel Programming | |||
| LOCATING A CHART SAVED IN A WORKBOOK | Excel Discussion (Misc queries) | |||
| Locating Latest Workbook | Excel Programming | |||
Linear Mode
