| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
xlDialogOpen get it to return Path
Hi
How can i get the XLDialogOpen to return the path of the file. ie C:\documents and users\someuser\my documents\test.xls Thanks. D |
|
#2
|
|||
|
|||
|
Instead use
Dim fName as String fName = Application.GetOpenFileName() fName will hold what you show. -- Regards, Tom Ogilvy "DMc2005" wrote in message ... Hi How can i get the XLDialogOpen to return the path of the file. ie C:\documents and users\someuser\my documents\test.xls Thanks. D |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Huge problem with "if" formula's | Excel Discussion (Misc queries) | |||
| Excel - return a picture or range rows as the result of a formula | Excel Worksheet Functions | |||
| How do create a formula to evalute a # to return 1 of 4 conditions | Excel Worksheet Functions | |||
| if the value of a cell in a range is not blank, then return the v. | Excel Worksheet Functions | |||
| How do link to a remote field but use the path from a stored field | Excel Discussion (Misc queries) | |||
Linear Mode
