Search and replace current month with last & and save as macro

[Gliori]

Hello there folks!


I need help with a code that will save the opel file as "jan-current month_current year". And I need the month to appear as text with three letters, for example it would be "jan-jun_2015" if I run the macro now. Is this possible to do?


Also when I use the search and replace tool in excel. Is it possible there to search for last month and replace with current month. Again, also there using only three letters for both search and replace, e.g search for may and replace with jun.


All help is highly appreciated!
Thank you in advance.


Kind regards!

 

[Gliori]

To be clear about the search and replace:

E.g if I have a cell that says may-15 I would like to change it to jun-15, if I run the code this month. Next month I would like to change jun-15 to jul-15, etc... So I thought maybe you could use something like change last month to this month in the code.

Cheers!

 

[Gliori]

I can also add that it's not formatted as dates, but just as general.