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

S

simonlavender

Joined
Apr 10, 2008
Messages
7
Reaction score
0
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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

MkDir question 5
Excel Excel VBA Macro to combine multiple workbooks into one 0
creating folders one level down 1
Saving A Copy 2
Mkdir with 2 variables not working .... 2
MkDir and Save As 2
Save range to text file. 1
Excel Excel VBA (Saving as A CSV) 1

Top