filename last month

Hi all,
I'm trying to work with a file that's always a month behind.

This works great for a file and location that's based on this month's name, but last month is a problem

Please Login or Register  to view this content.

the 17-18 in the path relates to the financial year, so will change, be great if we could automate that as well, but it's small enough to do this manually and leave it hard-coded

Obviously, it's more complex in January, when the year needs to be behind as well.

Google gave me this, but it's less than half the job.

Please Login or Register  to view this content.

also not sure how to tell LastMonth to not output the DD part since I only want Mmm YY

Can anyone help me finish this off?
thanks muchly

Try:

Please Login or Register  to view this content.

I'm not sure what you are looking for.

Please Login or Register  to view this content.

Hi again,

I'm nearly there

Please Login or Register  to view this content.

works fine apart from saving with the updated fname.

The open file changes name on the title bar of the excel window, but doesn't save. In place of spaces between the words, it has %20 instead.
Takes it's time to do it, excel crashed but recovered.

I've used this line of code exactly as is before, so I'm stumped. (Different values for the variables, different project file so it's not a variable clash)

Please Login or Register  to view this content.

Similarly, I'm almost certain the ChDir is redundant, but it didn't want to work without it so...

Lastly, the If Err doesn't do anything, doesn't give an error message, but the folder isn't created.
Folder creation was working without the iferror, but if the folder's already in place and the code is just mkdir, then I get an error...