macro save file for current year and month with a file name SHReportddmmyy.xls

[evwang]

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

[JapanDave]

Try this,

Please Login or Register  to view this content.

Dave

[evwang]

Try this,

Please Login or Register  to view this content.

Dave

Hello Dave,
Thanks a lot, and if there's a specific folder like "FX issue" after current year(ie:2011), how to put it please?

P:\Sh_BR\Departments\BASIC\COMMON\"Current Year(ie:2011)"\FX issue\YYMM\".xls"

[JapanDave]

If you post code make sure to use the code tags , and try not to quote entire posts.

Anyway , this should do the trick.

Please Login or Register  to view this content.

If this solves your problem , please mark the thread as solved and don't be afraid to give thanks by clicking the star in the lower left hand corner.

Edit: I did not read your post properly, please refer to updated code.

[evwang]

Morning JapanDave,
Other part is ok, just I meant that I've a folder which name each year (2010 or 2011 or 2012) before FX issue, do you know how to put it please?
Thanks VM.

Please Login or Register  to view this content.

If this solves your problem , please mark the thread as solved and don't be afraid to give thanks by clicking the star in the lower left hand corner.

Edit: I did not read your post properly, please refer to updated code.[/QUOTE]