'I run into an error when attempting to add today's date to file name

I suspect the error is where I attempted to add today's date to the filename.

ChDir _
    "C:\Users\xxx\PRODUCT MGT Position Tracking\Stock reports"
ActiveWorkbook.SaveAs Filename:="C:\Users\xxx\PRODUCT MGT Position Tracking\Stock reports\Stock by product by location " & Format(Date, "yyyymmdd").csv _
    , FileFormat:=xlCSV, CreateBackup:=False

date filenames

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution	Source

'I run into an error when attempting to add today's date to file name

Sources

Related Questions