Instead of struggling through reading, Speak Selection allows me to listen while I follow along with the words. On iOS, Speak Selection even highlights words as they are being spoken to help me follow along. With it, I can read webpages, newspaper articles, emails, and more. Speak Selection on iOS and OS X allows me to quickly highlight text and have the text read back to me using text-to-speech. Text-to-speech technologies that allow me to listen to text let me explore topics that I find interesting. Assistive technology allows us to do this independently it is our lifeline to the world of information. While this approach may not be considered 'real reading,' by some, when I and others like me listen to words being read aloud, the end result is the same - we get information from printed text. It's the way we get meaning from the printed word - by listening to it being read aloud. In any case try using the pick mechanism for the menu action, and see if that will work.For me, and many like me, reading using our ears is the method we use. Are you using an English localization on your system or something else? I’m surprised that you had a failure with my version, since I have it working here with Excel 2011 and El Capitan 10.11.2. With that you can actually pick the exact menu item from your target application. See the Menu pop-up on the right hand side of the Select or Show a Menu Item action? Keyboard Maestro will accept either the ellipsis character (’…’ via ⌥ ) or three periods to represent this kind of menu item. Your version leaves off the ellipsis on Import. Hmm… In your original macro I see you don’t have the correct suffix on the menu item. When I clicked “try” on your inefficient method, I got the same Alert in the upper right corner of my screen. Is there a way to read all of the Alert that pops up in the top right corner of my screen?īut – you can open the notification center and look for it in the list – you may be able to see more of the message there. Send me one of these files off-list to guessing it’s a tab-delimited file rather than a CSV file, but it’s best to work with real data and not have to guess. I have attached one of the files that I am importing into Excel. Good luck! I’ll try to get back to you soon. I think Chris may have written some Excel AppleScripts previously. You can google “Excel AppleScript” to get some ideas, and even search this KM forum. But please give it a shot yourself, if you like. I should have some time later and I’ll make the KM macro & AppleScript as an example. I just wanted to share this with you now. I think step (3) is best done in AppleScript, so you can avoid using the UI elements in a KM Action. If Excel has any prompts, you will manually respond.You select the file, whether it’s a CSV or TXT file (that’s the end of the KM macro). Make Excel open a file, looking in the “Acme Parts Update” folder.Download the files from the web for this use case into the “Acme Parts Update” folder manually, as you are doing now.I rarely let anything download to my “Downloads” folder. You call it whatever makes sense to you, that you will remember. Setup/create a specific folder for this use.It looks like a fixed format file, meaning each field in the file has the same number of characters on every line.īased on my limited understanding of your workflow, here’s what I’d suggest: txt file image you showed above is NOT a CSV file. I’d rather tell you too much than too little.ĬSV files are just TEXT files (you can open with TextEdit, TextWrangler, etc) with an extension of “.csv”, but they are supposed to have a special format inside, with each field separated by a comma. Please don’t be offended if I’m telling you stuff you already know, as I don’t know what your know. my apologies for not grasping the situation Also, when I did this manually, the Excel file that was created was beautiful and needed zero adjustments. That is the reason I wanted to click the “Text file” button that is on the bottom of the Import dialog box.
0 Comments
Leave a Reply. |