Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi Cereldine,
try this: sub GetPath dim pathandfilename as variant pathandfilename=application.getsaveasfilename if pathandfilename=false then msgbox "User quits the dialog" else msgbox "The path is: " & pathandfilename end if end sub this gives you the path and filename or false when user quits the dialog. Regards, Ivan |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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) |