| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Allowing the user to specify save location
Easy question I'm sure.....
How do I write code to save a file as the name in cell C2 but also allow the user to define the location (path) of the file? What I would like is the same as the window that pops up when you select File Save As in Excel. If I could get the file name to default (from cell C2) and then have the user take it from there to save to the location they want. How can I get there? I currently have the code below: Application.DisplayAlerts = False ActiveWorkbook.SaveAs Filename:=Range("C2").Value Application.DisplayAlerts = True |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro - save to current location vs excel default location | Excel Discussion (Misc queries) | |||
| How do I protect a number of sheets allowing the user to add a com | New Users to Excel | |||
| Allowing user to merge cells | Excel Discussion (Misc queries) | |||
| Allowing User to save file | Excel Programming | |||
| allowing user to format a protected cell | Excel Programming | |||
Threaded Mode
