Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change Directory
I manage several projects, and their documents are stored in various folders
on the server. I want to get to the folders quickly so I wrote several macros linked to buttons on my toolbar that appear as follows: ChDir "Z:\PROJECTS 2007\P0617-PARKDALE CHURCH" 'Z is a mapped drive to the server Application.Dialogs(xlDialogOpen).Show FullFilePath, vbNormalFocus When I click on the appropriate toolbar button, the File Open dialog appears, but the Directory hasn't changed to the one I want. What's up? TIA David |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change Directory
By specifying "FullFilePath" you override the current path. Just use :
Application.Dialogs(xlDialogOpen).Show -- Jim "Compass Rose" wrote in message ... |I manage several projects, and their documents are stored in various folders | on the server. I want to get to the folders quickly so I wrote several macros | linked to buttons on my toolbar that appear as follows: | | ChDir "Z:\PROJECTS 2007\P0617-PARKDALE CHURCH" 'Z is a mapped drive to the | server | Application.Dialogs(xlDialogOpen).Show FullFilePath, vbNormalFocus | | When I click on the appropriate toolbar button, the File Open dialog | appears, but the Directory hasn't changed to the one I want. What's up? | | TIA | David | | |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Change current directory to the directory that the workbook loads from! | Excel Programming | |||
Change directory | Excel Discussion (Misc queries) | |||
Change directory before File-Open | Excel Programming | |||
Change Directory Help! | Excel Programming | |||
Change directory for DOS window | Excel Programming |