Changing URL based on date

Hello. I'm trying to figure out how to have VBA return the value of the following month in mm format (i.e. 08 for August, not 8), based on today's date. As such, today it being the 7th month, I wish to return the value 08 (the 8th month).

I need the URL of

Please Login or Register  to view this content.

To essentailly be

Please Login or Register  to view this content.

but the way in which I have posted it above does not work!

Also, I need to define it such that as the month in question (in this example 08) will rename the subsequent part of the URL (here, August). So for example, next month (August), the URL should automatically become

Please Login or Register  to view this content.

If anyone knows how I could set this problem up in VBA i would really appreciate any help you could lend!

Originally Posted by nathansav

format(month(date)+1,"00")

What happens in december though?

Thanks that formatting works! For December I would just need to to set it up something like this?

Please Login or Register  to view this content.

Would that work? Also, do you know how I can set up a variable for the text month (AUGUST here), so that If Month(MyDate)=7, then MONTHNAME(or whatever the variable is called)=AUGUST?