VB Script to save excel file appending Month and Year in the filename

Hi,


Need assistance in creating VB script for saving an excel file that appends month and year.

Say my filename is: Sales Report + (January 2014).

Filename when saved should look like this: Sales Report (January 2014)


Thanks!