Excel Excel VBA - Saving workbooks and folders with MkDir and ChDir

[simonlavender]

Hi,

I want to save a workbook once a week/month after running a macro. A cell in the worksheet, e.g. G15 is YYYY and G16 is MM.

I want to save the file each month in a new folder and named YYYYMM, I can concatenate this (G15&G16) but how do I get the macro to recognise the cells?

I currently use MkDir "C:\File" do I need to bracket in activecell.select?

Thanks in advance!