Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Save As to a particular file location.
I have having using a macro to "save as" to a particular file
location. For some reason it was working and now it always saves the file to "my document". I don't know what happened. Below is the code, with the location I want to save it at in "local". Any ideas? Sub save() ActiveWorkbook.SaveAs FileFormat:=51, Filename:=Sheets("dashboard").Range("B6").Value & " Weekly Report " & Format(Date, "mmdd"), Local:="N:\Aarons Team\TSA Core Reports" End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
why can't i browse to a location to save a flat file | Excel Discussion (Misc queries) | |||
Save File in Desired Location & Name | Excel Discussion (Misc queries) | |||
how to save the same file in other location | Excel Discussion (Misc queries) | |||
Existing file not defaulting to same location using "Save As" | Excel Discussion (Misc queries) | |||
Save File to Another Directory, but not change Users File Save location | Excel Programming |