| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to get the full path name of the open workbook in a macro
How can I get the full path name for the open workbook using a macro? I
have tried using the CurDir() function but it is not working. eg. If I open my workbook from C:\Data\Excel\, I want to be able to get this string "C:\Data\Excel\" I am using excel 2000 on Win98SE --- Message posted from http://www.ExcelForum.com/ |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to get the full path name of the open workbook in a macro
How can I get the full path name for the open workbook using a macro? I
have tried using the CurDir() function but it is not working. eg. If I open my workbook from C:\Data\Excel\, I want to be able to get this string "C:\Data\Excel\" try this: strPath = ActiveWorkbook.Path & "\" -- Regards Melanie Breden - Microsoft MVP für Excel - http://excel.codebooks.de (Das Excel-VBA Codebook) |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to get the full path name of the open workbook in a macro
ThisWorkbook.Path & Application.PathSeparator
-- Rob van Gelder - http://www.vangelder.co.nz/excel "Flystar " wrote in message ... How can I get the full path name for the open workbook using a macro? I have tried using the CurDir() function but it is not working. eg. If I open my workbook from C:\Data\Excel\, I want to be able to get this string "C:\Data\Excel\" I am using excel 2000 on Win98SE --- Message posted from http://www.ExcelForum.com/ |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to get the full path name of the open workbook in a macro
Thank you for your replies. I have chosen to go with a combination:
ActiveWorkbook.Path & Application.PathSeparato -- Message posted from http://www.ExcelForum.com |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to see full path name of open workbook? | Excel Discussion (Misc queries) | |||
| Macro to open Workbook in default path. | Excel Discussion (Misc queries) | |||
| How to Display Full Path for File Diplayed at Top Of Workbook | Excel Discussion (Misc queries) | |||
| Workbooks.Open with out full path help needed. | Excel Discussion (Misc queries) | |||
| Getting the full path when from a File Open Dialog Box | Excel Programming | |||
![Flystar[_10_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
