you can find in the Quick-Text-Paste FAQ. It is easy to use! Some useful information. After only a short training period, you will profit forever. There are no limits to the imagination and possibilities of use, everyone is able to save a lot of hand grips with this program and thus a lot of time.
With the program, you can also manipulate the text selection fields by windows keyboard shortcuts, or even start Windows programs. You avoid wasting time on longer texts and avoid typing mistakes. Is to paste various texts, which are often required, such as the e-mail address or different document signatures at any time via predefined windows keyboard shortcut.
◆ Portable (Please create Portable QuickTextPaste.ini in Work Directory) ◆ execute programs from the command line (keyboard shortcut) ◆ paste signature images to a active program ◆ Special formats for Microsoft Excel and Word and other Office Tools!
◆ Working with date, time and calendar week ◆ Multiple commands as a selection (program starts) by single hotkey ◆ Selection of text fields by single hotkey Key features in Quick Text Paste for Windows Save time and spelling errors with this small Desktop Tool for all Windows OS is a popular tool f rom the category Office Tools! This program also allows you to run commands and programs via keyboard shortcut. That allows you to insert (paste) quickly predefined text in any Windows applications via keyboard shortcut. You can leave a response, or trackback from your own site.Quick paste text is a small freeware program You can follow any responses to this entry through the RSS 2.0 feed.
On Thursday, June 19th, 2014 at 11:53 am and is filed under General. ' Strip formatting when pasting buffer contentsĪctiveSheet.PasteSpecial Format:="Text", Link:=False, DisplayAsIcon:= _
To write/paste an arbitrary code macro, you can probably just “Record Macro” some trivial dummy operation (paste some text, etc.) then just replace the autogenerated code with your own. But once this is done, you can edit the actual code. You have to ‘Record Macro’ and physically do whatever action/mousedance to initially generate the equivalent code. There is no warning if you do overwrite an existing shortcut, so you’ll have to check on this yourself.Īt the time of this writing, Excel does not allow writing an actual macro (code) in the Personal Workbook directly. This is somewhat unintuitive and does not mean Excel is blocking you from overwriting an existing shortcut – just change the letter to lowercase and it’ll go away. Excel will automatically insert a ‘Shift’ in addition to this if you happened to type an uppercase letter in the sole letter box provided (they way keyboard shortcuts are usually represented in text). When assigning the keyboard shortcut, the “Ctrl” portion is mandatory and cannot be changed. This means I can no longer Ctrl-B to make text bold, but for the once-a-year I’d actually want to do this, it’s a plenty acceptable tradeoff.Ħ) Optional: Re-hide the “Personal” workbook. I just assigned it to “Ctrl-B” since it’s right next to Ctrl-V. Attempting to save a macro to it generates an extremely helpful message saying to use the ‘unhide’ option, without giving the option to just do this, nor telling you where this setting is.)ģ) Mousedance as above (Paste Special etc.)ĥ) Assign keyboard shortcut.
(The ‘Personal’ workbook is hidden by default. Store this macro persistently in the Excel “Personal Workbook”, not the currently open document, so it is available in any open document.ġ) View -> Unhide -> Personal etc. Traditional way: Mouse fandango (Excel 2013: Home -> Paste -> Paste Special…->Text->OK) for every time you want to do this.īetter: Create “PastePlainEffingText” macro activated by a nice fast keyboard shortcut equivalent to Ctrl-V. with extreme vengeance and only paste the plain text. In the process, strip any external formatting, HTML tables, etc. Very common need: Copy some data into an Excel cell from an arbitrary other source (including another Excel sheet, or webpage, etc.).