| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Open folder - Activeworkbook location
Is it possible to open the folder of the active workbook location from
File-Open?? Any macro pls |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Open folder - Activeworkbook location
Folders aren't opened. If you want the file=Open dialog to default to that
folder then make it the current directory with ChDrive Activeworkbook.Path ChDir ActiveWorkbook.Path fname = application.GetOpenFileName() -- Regards, Tom Ogilvy "al007" wrote in message oups.com... Is it possible to open the folder of the active workbook location from File-Open?? Any macro pls |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Open folder - Activeworkbook location
Hi Tom,
The macro works fine - except if i use it when the active workbook is a new one & has not yet been saved . What if error code do i have to add to make the macro default to my D:\ drive in that case & everything remaining the same otherwisse.. thxs Tom Ogilvy wrote: Folders aren't opened. If you want the file=Open dialog to default to that folder then make it the current directory with ChDrive Activeworkbook.Path ChDir ActiveWorkbook.Path fname = application.GetOpenFileName() -- Regards, Tom Ogilvy "al007" wrote in message oups.com... Is it possible to open the folder of the active workbook location from File-Open?? Any macro pls |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Open folder - Activeworkbook location
A file won't open also if activebook is from a drive only & is not in a
folder. Can this be fixed? Thxs |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| XLSTART Folder Location | Excel Discussion (Misc queries) | |||
| Temporary Folder Location | Excel Programming | |||
| open file from folder save in new folder | Excel Programming | |||
| Template Folder location | Setting up and Configuration of Excel | |||
| Copy Files from a folder to new location | Excel Programming | |||
Hybrid Mode
