Hi,

So i'm currently using this in VBA:

    Workbooks.Open ("Y:\X\X\X\" & Format(DateSerial(Year(Date), Month(Date) -1, Day(Date)), "mmmm") & "\SPR Information (" & Format(DateSerial(Year(Date), Month(Date) - 1, Day(Date)), "mmm-yyyy") & ").xls")
This SHOULD bring back: ("Y:\X\X\X\September\SPR Information (Sep-2013).xls)

But for some reason today it's bringing back: ("Y:\X\X\X\October\SPR Information (Oct-2013).xls)


Any idea why this is doing this.. it was working fine yesterday, but today its thinking that the month is November?

I've also tried changing -1 to -2, and thats bringing back August so thats a bit weird!

Any help - cheers!