storemannequin
Board Regular
- Joined
- May 29, 2010
- Messages
- 108
So I'm trying to understand how to save a workbook in a specific folder. Let's us 'C:\my documents' for instance as the directory. Can anyone help amend this bit to reflect this change? 'WBD' is the workbook I'm trying to save and 'mydocspath' is the file path to save to.
Code:
MyDocsPath = Environ$("USERPROFILE") & "\My Documents\"
FN = "ThisWB" & " For " & MonthName(Month(Date) - 1) & "_" & Year(Now) & ".xlsx"
FP = MyDocsPath.Path & Application.PathSeparator
WBD.SaveAs Filename:=FP & FN
WBD.Close savechanges:=False