Add month to file name in VBA

[phil Rutter]

Hello ALL
How can i add a month name to a file name using VBA?
Current code looks like this

Name "C:\Documents and Settings\phil\My Documents\PDF
files\AutoSave\ATB.pdf" As "C:\Documents and
Settings\phil\My Documents\Statistics-WSP\ATB\ATB-10.pdf"

When i try to add the following & MonthName(Month(Date) -
1, False)
it adds the text to the file name
if i remove it from the "" it adds it After the .pdf
statement which then PDF does not reconize?

 

[Cheryl Fischer]

You could try ...

"C:\Documents and Settings\phil\My Documents\Statistics-WSP\ATB\ATB-" &
Month(Date) & ".pdf"

hth,