| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
button that opens open dialogs but saves path to sheet
Hi Cereldine,
yes, it is possible to get path from full file name. You can use this function: Function Folder(FullFileNameIncludingPath) Dim fs As Object Set fs = CreateObject("scripting.filesystemobject") Folder = fs.GetFolder(FullFileNameIncludingPath) End Function Regards, Ivan |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Opening Excel, Book1 opens, remains open with other workbook open | Excel Discussion (Misc queries) | |||
| Excel UNC Path opens in Explorer | Excel Discussion (Misc queries) | |||
| Launching an XL file gives errors for each folder in path, then opens | Excel Discussion (Misc queries) | |||
| Excel saves the path of the printer with the document. | Excel Discussion (Misc queries) | |||
| Add a button to a sheet to open a userform | Excel Discussion (Misc queries) | |||
Threaded Mode
