Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Prompt for Save Path - Use Cell Content for File Name
Summary: User selected Path + File Name from a Cell to generate a 'Save
Path/file name' Details: I need to prompt the user for a Save To location. I want them to be presented with a browser box, not a cell where they have to type in a path manually. I need to take that path and a pre-generated file name and save. I'm currently generating the file name in a cell by using Concatenate... Then saving... ActiveWorkbook.SaveAs Filename:=Range("BZ21").Value If I pre-set the path this works fine. I just don't want to pre-set the path. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Prompt for Save Path - Use Cell Content for File Name
Hi
Maybe this is what you are looking for: MyFile = Range("A1").Value MyPath = Application.GetSaveAsFilename(initialfilename:=MyF ile, _ Title:="Select path") Regards, Per "Chris T-M" skrev i meddelelsen ... Summary: User selected Path + File Name from a Cell to generate a 'Save Path/file name' Details: I need to prompt the user for a Save To location. I want them to be presented with a browser box, not a cell where they have to type in a path manually. I need to take that path and a pre-generated file name and save. I'm currently generating the file name in a cell by using Concatenate... Then saving... ActiveWorkbook.SaveAs Filename:=Range("BZ21").Value If I pre-set the path this works fine. I just don't want to pre-set the path. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
File Save Macro as Cell content | Excel Programming | |||
prompt user to save file as {desired_name} and save it to a variab | Excel Programming | |||
save prompt for user exit, but no save prompt for batch import? | Excel Discussion (Misc queries) | |||
Save as using cell content in file name | Excel Programming | |||
Save file path in cell | Excel Programming |