Variable day expiry date

Thanks for giving the link to your cross post as is required in the rules but you forgot to mention this one!

The code you supplied is exactly the same the question is very slightly different ergo following the same line of questioning, posters at all these sites may be working towards the same solution for you and it is only fair that the have knowledge of the other posts to see what has or has not been tried!

sujittalukder

You cross post constantly and have been rebuked many times on ozgrid 7 here. I could easily point you to some code posted by my friend jack, but can't be bothered as you can't be bothered to let us know when you cross post.

RoyUk thanks for the info and support!

Not a problem Simon, I am rapidly losing patience with this OP & will not offer any more help to him/her.

Dear royuk, i have only cross posted once in ozgrid without any information and that was my first post , not at ozgrid , but at any forum for which i apologized Thereafter whenever I have posted at more than one forum, I always provided link. So concluding that you will not offer help is not fair and justified.

Dear Simon , Its true that the codes that I have supplied are same as because my questions are based on those codes but final question is not same

In the posts at this forum (Which is posted at mrexcel also) I am searching for a solution which will expire a WB after some days of opening of the file and obviously on the basis of system date which , say for eg after 7 days,because the code I have provided contains a fixed date so creates a problem for me to distribute a file on trial basis.

In the post at vbaexpress, my requirement is that the time should not be related to system date rather than it should take the date from some online system so that even if the user changes system date the file should not work.

So how can these two be said as cross post simply on the basis of the code in the problem? Though your suggestion is good that the solution may be same or would help others to get a solution This I could not recognize as beacause the rule says to inform about the cross post - means having same question and requiring same solution. neverthless i will keep the same in mind while future posting.