| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
I hate paths!
Could someone please tell me how to indicate current path in VBA when using
Excel? When I record a macro usinly excel, for example in haveing anothe workbook open, it always includes the full path. What I want is for the Workbook to be opened in the current directory, so I can move this directory to other computers and have it the macro work without having to change paths at each new machine. I tried ./, but that didn't work for me. Ross |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
I hate paths!
See VBA help for CurDir
-- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Ross" wrote in message ... Could someone please tell me how to indicate current path in VBA when using Excel? When I record a macro usinly excel, for example in haveing anothe workbook open, it always includes the full path. What I want is for the Workbook to be opened in the current directory, so I can move this directory to other computers and have it the macro work without having to change paths at each new machine. I tried ./, but that didn't work for me. Ross |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
I hate paths!
I think you are looking for Thisworkbook.Path after reading your other thread
-- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Ron de Bruin" wrote in message ... See VBA help for CurDir -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Ross" wrote in message ... Could someone please tell me how to indicate current path in VBA when using Excel? When I record a macro usinly excel, for example in haveing anothe workbook open, it always includes the full path. What I want is for the Workbook to be opened in the current directory, so I can move this directory to other computers and have it the macro work without having to change paths at each new machine. I tried ./, but that didn't work for me. Ross |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| DISPLAYING THE LINK PATHS | Excel Worksheet Functions | |||
| Help with filenames and paths. | Excel Discussion (Misc queries) | |||
| i hate your formatting popus | Excel Discussion (Misc queries) | |||
| file paths | Excel Discussion (Misc queries) | |||
| Another Reason to Hate Insurance Companies (as if you needed one) | Excel Worksheet Functions | |||
![Ross[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
