Alexis

Thanks acantor and Cory for your input. @acantor: Yeah i guess its just like that. So it´s good to have in mind that sometimes there is still a keyboard shortcut even without accelerator keyhints. For automating with MEX keyboard shortcuts are much more reliable and faster than pressing Menus (simulating mouseclicks) @Cory: Yes and now. MS translates a lot of the original/english language and sometimes pretty poorly. Most menus and also keycommands are translated. In Word for formatting text into Bold or Italic the german expressions are "Fett" and "Kursiv". And here the key shortcuts change from CTRL + SHIFT + B, I to CTRL + SHIFT + F, K. On the other hand the print command (CTRL + P) maybe translated but the keycommand is never changed. It´s CTRL + P in almost every (german) software. Some kind of inconsistency there. Thank you guys for contributing to this topic.

Interesting, than this example (H) does not work. To experience the same message i got (see my foto) with ALT, T i guess you need to press a letter which does not come up if pressing merely ALT and wating for the shortcuts to appear.

I don´t think they behave different due to languages. Let´s find out. Two questions for english users: If you press merely ALT do you see the letterhint "H" anywhere? What happens if you press ALT + H?

Does anybody see the difference between Way 2 and Way 3?

Well they are hidden. I use the german Excel Version. For renaming the sheet the correct sequenze is actually Alt + T, B, U in the german Version. I do distinguish between the accelerator way and the sequenze way. In my last post i numbered those ways 2 and 3. There is a distinction, cause when i press only the ALT Key indead a lot of numbers and letters appear but not one letter "T"! After pressing T instead a message appears (siehe picture). This is a complete different behaviour than using merely the ALT Button and waiting for accelerator key hints to appear which change and are narrowed down if you are use one of those. Do you understand the difference between Way 2 and Way 3? In the appearing textbox Excel refers to older Excel Versions where i guess in Pre Ribbon Versions using those keysequences was the same as typing the underscored letters in the menus as in Office 2003 Versions. BTW the sequence way is much quicker than the accelerator way. In my Excel 2016 it takes quite some time for the accelerator keyhints to appear. It´s a shame that the Sequence Shortcuts are not documented although we could ask someone who is using Office 2003.

Dear Acantor, actually there are 3 Ways. 1. Preprogrammed Keycombinations like CTRL + SHIFT + B for Bold in Word (same in Excel) which you can change (in Word) 2. Accelator Keys, which you mentioned as 1. in your last post 3. And Keycombinations liket ALT + H, O, R mentioned above. This was new for me. I will name it "Nonaccelator, serial Shortcut" for now. I did google it but was only able to find single shortcuts but never a complete reference of those hidden "Serial shortcuts". Could you provide a link here with a reference if there is any? I guess a lot of MEX User are automating MS Office applications and in oder to do this a keycombination is very useful.

Thank you very much Cory and acantor!! I like the idea of copying the Sheetname while editing then aborting the edit. You don´t loose focus of the current activated cell. Great idea!! But how did you know the keycombination Alt + h, o, r for renaming sheets? Is there a documentation of those keycombinations. I mean it´s quite a different shortcut-approach then just pressing ALT and waiting for EXCEL to display the options. Actually T is not listed if you press ALT once. There are so smart people here!

Hey there, is there a way for Macro Express Pro to get sheet names from an excel file that has multiple sheets? Thanks in advance.

Well, i guess it´s worth suggesting that MEP gets clipboard variables, no?

Actually i would love to have also the opportunity that a MEP variable saves the whole clipboard (without cleaning)

@ rberq. You may check what format is "Standard" in your word version. This definition ist stored in the document or in new documents in the Normal.dot(m) in Templates. It´s likely that Word uses this format. Also consider that you can define in word which format (source or target) it should use if pasting from other or same (Word) Applications in the preferences of word. By pressing CTRL after pasting you can change that default behaviour manually.

That´s what i thought. The clipboard as a global utiltiy but all those applications are quite interpreting what to do with the content of the clipboard. Sometimes quite unpredictable. Thank you for offering further understanding and help.

Thank You, great advice as always!!! It works in Wordpad using a .rtf-file. I never would have thought of this. It must have something to do with the fileformat (doc vs rtf) and what actually is the content of a rich text clipboard. I don´t really understand it but am i happy you showed me the way.

Greetings, when I use "Text Type --> Paste Rich Text" in a Word Document it also changes the Pagelayout. Is there a way to prevent that from happening? Atm I use "Use Cliptboard and Paste Text" instead which works fine but doesn't let me pre-format text.

MyLifeOrganized is a program where you can manage your Tasks. In the example above {4B3B139D-0A06-4389-A5F2-FD5D120D45EF} is the ID of an task. With the command above you can select specific tasks in MLO. The command aktivates MLO and selects the task (one of thousands ;-)

I'm using MEP on a Surface Pro 4, it runs on a 2736 x 1824 (267 PPI) resolution. The overall Font of MEP is pretty small and the Icons are TINY. Is there a way to change the size of the Buttons/Icons and the font size of the MEP explorer the same way you can change the font size of the script editor?

Multiplying the hour by 100 is a great idea!!

Still i find the way using one variable more elegant than dealing with 2 (hour and minute) where you need IF AND commands. @Cory: I checked my posts before posting. Could it be that posts vanish? It says i made 261 posts. But only the last 4 of 2015 are shown. Why? Could be that some people are reposting stuff because of that.

Cory, it was all about checking if it´s later than a certain time each day. I came up with the idea to subtract the integer part of the resulting decimal. So the date doesn´t matter. Alan came up with creating directly an hour and an minute integer. Everything is mentioned above. Thank you Alex

Alan, with your approach of two different variabels you have to use IF / AND combination of commands for every time check. But you don´t neeed to conversion of DT Variable and the Truncation before. Both methods are possible. Thanks for sharing insights!

Thank you but i don´t see where your macro reads out the current time. This is my approach for checking if current time is between 7:00 to 12:45 and i don´t think it´s clunky. <DATE/TIME Flags="\xB0" Date="24.02.15 10:45:00" Day_Offset="0" Month_Offset="0" Year_Offset="0" Hour_Offset="0" Minute_Offset="0" Second_Offset="0" Left="Center" Top="Center" Monitor="4" Variable="%Jetzt%" IsDateVar="TRUE"/> <CONVERT DATE/TIME TO DECIMAL Source="%Jetzt%" Dest="%JD%"/> <VARIABLE MODIFY DECIMAL Option="\x06" Destination="%JD%" Variable="%JI%"/> <VARIABLE MODIFY DECIMAL Option="\x01" Destination="%JD%" Value1="%JD%" Value2="%JI%"/> <IF VARIABLE Variable="%JD%" Condition="\x03" Value="0,29166666" IgnoreCase="FALSE"/> <AND/> <IF VARIABLE Variable="%JD%" Condition="\x05" Value="0,4583333333" IgnoreCase="FALSE"/>

Got it: I convert the DT-Variable to Decimal. I truncate the Decimal to Integer, save this Integer and subtract this Integer from the entire Decimal. So i eliminate the date portion.

Thank you so far. I´m getting closer. But now that i want the macro to do A if it´s earlier than 10:45 and to do B if it´s later than 10:45 what are exactly the "If Variable commands" and Variables i need to use. I need to convert the DT Variable to Decimal before, no? And is the number in this Decimal created by the date not disturbing? I tried extracting hour and minutes but then i have to write different If commands including clunky AND Operations for hours and minutes if i treat them as strings.

Acutally it seems simple but somehow i can´t figure it out. I want to have a macro timespecific while the current date doesn´t matter. The date should be ignored. For time calculations i convert the date/time variable into an decimal variable, right? So for the 19. of June Time 10:45 i get 42174,4479166667. The number left from the comma is the date. The number right from comma is 10:45. How can create a date/time variable without the date portion? Or how can i delete that portion in the according decimal variable? Thanks a lot Alex

You guys are great. This works: <PROGRAM LAUNCH Path="C:\\Program Files (x86)\\MyLifeOrganized.net\\MLO\\mlo.exe" Mode="\x00" Parameters="\"C:\\- Dropbox\\My Dropbox\\Public\\Alex.ml\" -task={4B3B139D-0A06-4389-A5F2-FD5D120D45EF}" Default_Path="TRUE" Wait="1" Get_Console="FALSE"/> Although i use MEX Pro 4.4.1.1 it has to be exactly like both of you discribe it. Thank you so much! This will accelerate my workflow quite a bit! :)