Hi Marc and Robin, I believe Ken's idea is worth considering, however, it should come with some caviotts: you don't just lose the color of the text when you paste like this; you lose *all* formatting, which includes underlining, bolding, sizing, and even the paragraph characters (they aren't text). It can really leave you with a mess if you had highly formatted text to begin with. Reformatting the text is only possible when you know exactly how it looked before you started.
I think it's much easier, if color is all Robin is concerned about, to select the entire document after all pasting is done, and then to click on the font color button in the "home" ribbon tab (I don't know why but Window-Eyes seemed to speak the dialog choices slightly better if you used the button to get to the dialog than if you used the context menu choice). Then, just take the mouse cursor and go to the top of the color dialog and click on the "automatic" choice with the mouse (as I had difficulty getting Window-Eyes to find and speak this choice using the keyboard). That's it! You now have uniformly colored text, and unless you've done something to your default settings, it will be black. I think you have an "ok" button to click on if you came in via the context menu "font" item. If you can do this with HotSpot Marc's right, it's by far the easiest, but I didn't see keyboard shortcuts for the colors, and without those it isn't so easy, and when dialogs are opening and closing, and you need to pause to let a dialog open before doing the next step, well I am not sure how easy it will be. I admit to not being an experienced hotspotter. Robin, let me know if you try this and it seems easy enough and if it works. Hth, Chip -----Original Message----- From: Talk [mailto:[email protected]] On Behalf Of Marc Solomon via Talk Sent: Friday, June 12, 2015 3:38 PM To: Van Lant, Robin; Window-Eyes Discussion List Subject: RE: best way to accomplish this macro? Below is another suggested solution that came from Ken Scott. He isn't subscribed to the list and asked me to post the message on his behalf. Hi Marc, I am hoping that my guess on how to reach you is correct. I am not subscribed to the talks list so I am writing to you to offer an easier method to address a concern of a list member. I hope that you will forward the following information to the talks list. Mr. Van Lant does not need to create a macro. All he has to do when pasting text is press the context menu key down arrow to where Window-Eyes announces keep source formatting. He then arrows right until he reaches the keep text only option and presses enter. This pastes the text into the destination document and applies the destination document's formatting. If he needs specific formating, he can create a Word document or template with any required formats. This should be a lot easier than trying to create a macro. I am assuming that Mr. Van Lant is using fairly recent versions of Window-Eyes and Microsoft Office. Best Regards, Ken Scott -----Original Message----- From: Talk [mailto:[email protected]] On Behalf Of Van Lant, Robin via Talk Sent: Friday, June 12, 2015 1:36 PM To: Window-Eyes Discussion List Subject: best way to accomplish this macro? I'm thinking I want to create a macro that will enable me to quickly apply a font color change to selected text. Usually what I'm trying to do is to select all the text in an office product (be it Word, Excel or Outlook) and select black font to ensure that my font is a consistent color after cutting and pasting from multiple sources. In office 2010, the font color selection tools are more cumbersome and I don't fully understand them, but I've managed to muddle through to select black. This takes multiple keystrokes and often my mouse, too. Curious as to which is the best tool for creating macros. I'm considering the Office macros, the Read Macro app on App Central, and the HotSpot app. What some of the differences would be. I image the Office macro would be specific to the particular program, whereas both WE apps could be potentially used across platforms (maybe not in my specific situation above). Any other thoughts on the pros and cons to the various means for creating a macro and why I might choose one over another? What other things have you found useful to create with HotSpot and Record Macro? Robin Van Lant | Sr. Program Manager Strategy & Performance Management | Key Equipment Finance 720-304-1060 | [email protected] This communication may contain privileged and/or confidential information. It is intended solely for the use of the addressee. If you are not the intended recipient, you are strictly prohibited from disclosing, copying, distributing or using any of this information. If you received this communication in error, please contact the sender immediately and destroy the material in its entirety, whether electronic or hard copy. This communication may contain nonpublic personal information about consumers subject to the restrictions of the Gramm-Leach-Bliley Act. You may not directly or indirectly reuse or redisclose such information for any purpose other than to provide the services for which you are receiving the information. 127 Public Square, Cleveland, OH 44114 If you prefer not to receive future e-mail offers for products or services from Key send an e-mail to mailto:[email protected] with 'No Promotional E-mails' in the SUBJECT line. _______________________________________________ Any views or opinions presented in this email are solely those of the author and do not necessarily represent those of Ai Squared. For membership options, visit http://lists.window-eyes.com/options.cgi/talk-window-eyes.com/msolomon%40ais quared.com. For subscription options, visit http://lists.window-eyes.com/listinfo.cgi/talk-window-eyes.com List archives can be found at http://lists.window-eyes.com/private.cgi/talk-window-eyes.com _______________________________________________ Any views or opinions presented in this email are solely those of the author and do not necessarily represent those of Ai Squared. For membership options, visit http://lists.window-eyes.com/options.cgi/talk-window-eyes.com/lists3717%40co mcast.net. For subscription options, visit http://lists.window-eyes.com/listinfo.cgi/talk-window-eyes.com List archives can be found at http://lists.window-eyes.com/private.cgi/talk-window-eyes.com _______________________________________________ Any views or opinions presented in this email are solely those of the author and do not necessarily represent those of Ai Squared. For membership options, visit http://lists.window-eyes.com/options.cgi/talk-window-eyes.com/archive%40mail-archive.com. For subscription options, visit http://lists.window-eyes.com/listinfo.cgi/talk-window-eyes.com List archives can be found at http://lists.window-eyes.com/private.cgi/talk-window-eyes.com
