Sebastian42 Posted June 23, 2020 Report Share Posted June 23, 2020 CTRL: inserts the date in Excel; I want that functionality on a hotkey in Windows. I think it is likely that it already exists - but what is it ? Quote Link to comment Share on other sites More sharing options...
acantor Posted June 23, 2020 Report Share Posted June 23, 2020 Date/Time: Type out the current date/time using "d mmmm yyyy" as the format I use "d mmmm yyyy" format for my macro, but it can be changed to whatever format suits you. Quote Link to comment Share on other sites More sharing options...
Sebastian42 Posted June 23, 2020 Author Report Share Posted June 23, 2020 Had written a detailed account about not knowing how to apply your code, then discovered Date/Time in Variables command, set the format I wanted, and presto - it works. Thank you. However, what if Macro Express is not yet launched ? Ideally, JUST pressing CTRL D should enter today's date - Will that require M.E. to be launched at (every) StartUp ? Quote Link to comment Share on other sites More sharing options...
acantor Posted June 23, 2020 Report Share Posted June 23, 2020 That's right. Macro Express must be running. You can set Macro Express to start automatically whenever your computer starts: From the Macro Express Explorer: Options Preferences... Startup Windows Startup Run when Windows starts up [check] Quote Link to comment Share on other sites More sharing options...
Sebastian42 Posted June 23, 2020 Author Report Share Posted June 23, 2020 If I can not get M.E. to be launched as needed, then I will just launch it with windows. Quote Link to comment Share on other sites More sharing options...
kunkel321 Posted June 23, 2020 Report Share Posted June 23, 2020 A system that I've used for a long time is that typing ; in front of a string is a trigger for an autotext entry. For example ;brb = be right back For dates I use ;d Also I have a number that indicates offset though... ;d0 = today ;d1 = tomorrow ;d3 = day after tomorrow. ... ;d9 = nine days from now. At first I used ;d-1 for yesterday ;d-2 for day before yesterday, and so on. Over the years it evolved into ;dd1 ;dd2 ;dd3 Which is easier to type. Unfortunately these have to be created as separate macros. I'm in the process of changing computers, so I've uninstalled MEp, otherwise I'd post an example. The code is not complicated though... 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.