update link with wildcard?

[13lack13lade]

i have the following code and i need to remove May 2014 with a wildcard so that everymonth i dont need to change the code however i get a debug when i change it to *.xlsm"

Please Login or Register  to view this content.

[mrice]

Assuming you wnat to go to the current month

Please Login or Register  to view this content.

[13lack13lade]

Hmm that doesn't seem to work, when i run that code it still needs me to select the book.. i need it to automatically select the workbook as this will be run off a script so there is no user involvement.

Any other ways? - i would like if it was possible to use a wildcard instead of a date, as then i can use it for a few other links just incase someone changes the name slightly.

[13lack13lade]

anyone able to assist?

[13lack13lade]

anyone at all?