Hello everyone, thank you. Here is my question. I need to save a file using the date and the sheet name, in that order, like this:

ActiveWorkbook.SaveAs Filename:=Format(Now(), "yymmdd") & ActiveSheet.Name, FileFormat _
:=xlText, CreateBackup:=False

This code works fine, except that it saves only to whatever directory you are already in - but I need to change directory.

So I wrote:

ChDir "\\Buffalo\website\AmazonPriceQtyUpdates"
ActiveWorkbook.SaveAs Filename:=Format(Now(), "yymmdd") & ActiveSheet.Name, FileFormat _
:=xlText, CreateBackup:=False

The result is, the directory is not changed - it ignores that instruction and saves in the current directory I am in (My Document!)

If I write the whole saveas filename routine then the instruction to save the date in front of the sheet name does not work anymore and I get a compile error. Like this:
ChDir "\\Buffalo\website\AmazonPriceQtyUpdates"
ActiveWorkbook.SaveAs Filename:= _
"\\Buffalo\website\AmazonPriceQtyUpdates\Format(Now(), "yymmdd") & ActiveSheet.Name", FileFormat:= _
xlText, Password:="", WriteResPassword:="", ReadOnlyRecommended:=False _
, CreateBackup:=False

Please help - what am I missing?