woelmuis Posted January 25, 2006 Report Share Posted January 25, 2006 Hello everyone I have a small problem and I hope somebody can help me. I need to choose a date with macro express and after done that the programm shoudl open a notepad and fill in: - date date which I choose PLUS (and that's my problem) the date choosen adding 90 days. So two dates must be filled in, in the notepad Does somebody have any idea?? Thanks for reading Regards Barolt Quote Link to comment Share on other sites More sharing options...
lemming Posted January 25, 2006 Report Share Posted January 25, 2006 Seems straightforward, at least with the latest version. See screencapt. Quote Link to comment Share on other sites More sharing options...
woelmuis Posted January 25, 2006 Author Report Share Posted January 25, 2006 Thank you for giving me an answer. Maybe I didn't descripe my problem enough. I want to choose only (one time) a certain date. From there the macro should place the choosen date in my notepad, making a new line and place calculating from the first date PLUS 90 days. The printout on notepad (word etc) should be: ------------------------- Date choosen: 29 March 2005 Added days: 90 New Date: 27 June 2005 ------------------------- Quote Link to comment Share on other sites More sharing options...
lemming Posted January 25, 2006 Report Share Posted January 25, 2006 Ah, now it's clear. Looks like you need to do a few calculations. Fortunately, you don't have to reinvent the wheel. The fellas at PGM have developed a whole bunch of Date and Time functions: http://www.pgmacros.com/date_and_time.htm Quote Link to comment Share on other sites More sharing options...
woelmuis Posted January 31, 2006 Author Report Share Posted January 31, 2006 THANK YOU VERY MUCH!! Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.