Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Save As
ActiveWorkbook.SaveAs Filename:= _
"U:\FolderOne\FolderTwo\Folder3\", _ FileFormat:=xlNormal, Password:="", WriteResPassword:="", _ ReadOnlyRecommended:=False, CreateBackup:=False Hi, How do I change the above so it opens the save as dialog box to Folder3, but allows the user to change the location and use any name to save? the above version doesn't work because there is no workbook name after folder3... thanks a lot.... SteveC |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Save As
Give this a try...
Application.Dialogs(xlDialogSaveAs).Show "U:\FolderOne\FolderTwo\Folder3\" -- HTH... Jim Thomlinson "SteveC" wrote: ActiveWorkbook.SaveAs Filename:= _ "U:\FolderOne\FolderTwo\Folder3\", _ FileFormat:=xlNormal, Password:="", WriteResPassword:="", _ ReadOnlyRecommended:=False, CreateBackup:=False Hi, How do I change the above so it opens the save as dialog box to Folder3, but allows the user to change the location and use any name to save? the above version doesn't work because there is no workbook name after folder3... thanks a lot.... SteveC |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Save As
Great, thanks!
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Save, save as, page setup dimmed out in unprotected excel sheet? | Excel Discussion (Misc queries) | |||
Save As and save current numbers not the actual formulas and links | Excel Discussion (Misc queries) | |||
how to get disk icon on save button of save as dialog like 2000 | Excel Discussion (Misc queries) | |||
Totally Disabling (^ save ) (Save as) and Save Icon – Which code do I use: | Excel Programming | |||
when i save xls file, debug script is running and canno't save fil | Excel Discussion (Misc queries) |