Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
SaveAs Dialogue Box
Hi, I am trying to save a file to directory. I want the saveas dialogue box
to pop up with the file name and pathe I specify, but I want the user to be able to change the path given that it changes on a monthly basis. With Sheets("MissingSTAvg_Corp") .SaveAs Filename:= _ "Q:\Results\March 06\MissingSTAvg_Corp" & InputBox("Please Enter Date As MM-DD-YY") End With The "March 06" will change monthly. Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dialogue Box | Excel Discussion (Misc queries) | |||
dialogue pop up | Excel Discussion (Misc queries) | |||
pop up dialogue box | New Users to Excel | |||
pop up dialogue | Excel Discussion (Misc queries) | |||
Dialogue Box | Excel Programming |