c:\MarketAction s and not in the subfolder \Egypt.
Where is the problem?
Code:
Sub SaveFile()
ActiveWorkbook.SaveAs ("c:\MarketActions\Egypt\" _
& Format(Now(), "YYYYMMDDHHMM") & ".xlsm")
End Sub
Petertheo
Last Activity: Aug 18 '15, 09:34 PM
Joined: Aug 18 '15
Location:
-
Autosaving file by date as part of the file name
When I use this code the file is only saved at:
c:\MarketAction s and not in the subfolder \Egypt.
Where is the problem?
Please adviseLast edited by Rabbit; Aug 18 '15, 04:11 PM. Reason: Please use [code] and [/code] tags when posting code or formatted data.
No activity results to display