I wanna save excel to a path defined for current year (YYYY) and current month & year (MMYY) with a file name SHReportddmmyy.xls

for example: P:\Sh_BR\Departments\BASIC\COMMON\YYYY\MMYY\SHReportddmmyy.xls

Highly appreciated if anyone could help on this.
Thanks very much in advance.

Regards,
EV