Autosaving file by date as part of the file name

[Petertheo]

When I use this code the file is only saved at:
c:\MarketAction s and not in the subfolder \Egypt.

Where is the problem?

Sub SaveFile()
ActiveWorkbook.SaveAs ("c:\MarketActions\Egypt\" _
 & Format(Now(), "YYYYMMDDHHMM") & ".xlsm")
End Sub

Please advise

[Stewart Ross]

On the basis that there is nothing obvious wrong in what you have posted I suspect that this sub may not be executed as it stands. If the sub folder Egypt was incorrectly named, say, Excel would tell you that the path was invalid. If you have Excel's warning messages turned off then you would not get notification of an error, but nor would the file be saved. Saving one folder up is not behaviour that I recognise.

I suggest you set a breakpoint in the code which calls the sub, then step through it line by line to check what is going on. Make sure you start with no previous files saved in your folders to avoid potential confusion of your tests.

-Stewart