Creating a file in a directory of last months name

[DellHater]

Hi

I need to amend my existing macro, so that instead of putting a file into a specific folder, I have to put it into a folder called last month.
For example

create a file called test.txt in a folder called C:\test\July
for this month and next month in a folder called C:\test\August

is there a quick way I can do this?

thanks

 

[SkipVought]

Hi,

LastMO = Format(DateSerial(Year(Date),Month(Date)-1, 1),"mmmm")

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[DellHater]

HI thanks for the quick response,

how can this be dropped in to a path name ??

currently
ChangeFileOpenDirectory _
"C:\test\"
how do I get the string value added to the path above ?

thx a lot

 

[ettienne]

C:\test\" & LastMO