Office and Browsers

Office applications and Web browsers – Tips and macros that make life easier

Macros to “Paste as Text” for Word and Excel

2017/11/07
By
Modified: 2017/11/05
Macros to “Paste as Text” for Word and Excel

These two macros will save you a lot of time.  They used, when you need to copy something from Internet page into a Word or Excel document, but  you do not need all the colors and formatting.   You just need the text. Usually you would do this with Paste Special, but this is several awkward clicks and many seconds lost.  Over the course of the day this is a huge inefficiency. Let’s write a macro for Word first. As of 2012-01-11 WED, I adopted this little macro as final version: Sub PasteText() On Error GoTo Unicode Selection.PasteSpecial Link:=False, DataType:=wdPasteText, _ Placement:=wdInLine, DisplayAsIcon:=False GoTo Done Unicode: Selection.PasteAndFormat (wdFormatPlainText) Done: End Sub This macro…

Read more »


Office 2010 Encountered an Error During Setup – Many Sulutions

2017/10/26
By
Modified: 2017/09/16
Office-2010-Error

You are an expert.  You are almost a god. You can manipulate complex installs and difficult projects.  This time you just want to test Office 2010, and be done with it. […This article is quickly growing.  There are surprisingly many nuances behind behind this simple facade  ——>] You quickly create a fresh Windows instance, by copying 3 or 4 directories from some backup storage, and you boot into it. Now, you are trying to install a fresh Office 2010 on a fresh install of Windows (any version including XP, Win7 and W2K8 R2). Everything great and dandy, but you are interrupted with this very informative error message: Microsoft Office Professional 2010…

Read more »

Share Digital Certificate for VBA Between Several PC(s)

2017/10/18
By
Modified: 2017/09/16
Excel-Install-Certificate

This article is about time saving, when it comes to enable your macros in Excel every time you open the file. You do not want to allow all macro to run.  But if you don’t, you have to constantly enable your macros over and over again, when you open your Excel files.  To eliminate this, you can create a self-signed digital certificate and this work fine on one PC. But what, if you need to open the same files with macros from several PC(s) on your network.  I think I found a solution on how to create a certificate on one PC and then install that certificate on other PC(s). This…

Read more »

Keyboard Shortcuts for Next, Previous, Euro, Degree Symbols and Moving Around Inside a Worksheet

2017/10/15
By
Modified: 2017/11/05

I never can't remember the Notepad equivalent of "F3" (Find Next) in Word and Excel. Here are the keyboard shortcuts, that are most useful, but almost impossible to remember. Also I constantly need Euro currency symbol (€) and Temperature Degree symbol (°), when writing my travel notes about Europe.

Read more »

Office 2010 – Setup – Configure – Reinstall

2017/09/30
By
Modified: 2017/09/16
Office Pro Plus 2010 Activation

First to Note Office 2010 is a true heavy weight. It more than doubles the size of your registry on a fresh Win7 or Win XP instances. Full Office version requires an activation right away, if you install it on top of your Evaluation copy. You still can open applications without activation, but you can’t  Save, Print or set options.  Trial version allows to work without activation for 29 days.  You can see the day remaining counter in File – Help window. Template Normal.dotm from previous Office 2007 are still working.  They can be shared on the network among Word 2007 and Word 2010.  The same is true for an XLSTART file.…

Read more »

How to Run Malicious Software Removal Tool?

2017/09/28
By
Modified: 2017/09/16
Malicious Software Removal Tool

MRT Just 3 letters you need to know – MRT That is right, just type MRT.exe in you Start – Run box.  Why they hide it so deep?  Why there is no easy answer anywhere on the Internet? The program is located in %WinDir%\System32\MRT.exe Once again, to run Malicious Software Removal Tool type MRT in your  Start – Run box. In this article I am going to: – Accumulate information about annoying files that push themselves in the registry; – Show how to write a small CMD script that will continuously clean your registry Run locations; – Describe how to secure your Internet Explorer to lower possibility of malware infection; –…

Read more »

How to properly zoom in Word and Excel – Ctrl+[+] and Ctrl+[-]

2017/08/15
By
Modified: 2017/06/25

    This is cool!   This is fresh!  Make your Word and Excel to respond to human zoom commands like normal applications. In most modern applications you can zoom in and zoom out current window using fast Ctrl + Plus and Ctrl + Minus keyboard shortcuts.   Not so in Word and Excel.  Even in the latest ones – from Office 2013 – you do not have this functionality.  Finally, finally here in this article you learn how to do it with macros.  Word partial idea was published before on other site (see below), but Excel technique uses new and exciting macro.   WORD To make keyboard combinations Ctrl+[+] and Ctrl+[-] to work in Word…

Read more »

WordPress: Image Editor is not loading in IE under tight security

2017/08/09
By
Modified: 2017/06/25
WordPress - Image Editor is not Loading

Let’s say you have a very thigh zone security setup in IE.   All Internet sites are set to High security level, and  Trusted sites are set a Medium-High. In that case you might experience a painful WordPress problem – Image Editor is not loading in IE.  It is getting stuck on a dark loading image. Symptoms: when you click on Add an Image or Edit Image buttons, all you see is your screen is darkening and running image in the middle imitating loading is staying on, forever. To solve this problem without killing your security settings add site about:blank to you trusted site list and here we go – problem is solved!

Read more »

Apply Color Scales Conditional Formatting to Multiple Rows in Excel

2017/07/24
By
Modified: 2017/06/25
Excel - Color Scale Conditional Formatting

When you might need to apply color sales Conditional Formatting to multiple rows in Excel using a Macro?  We found that is most useful, when you have a perfectly arrange row-by-row conditional formatting, and you are trying to insert a new row.  You can try to fix the resulting formatting rules mess manually, or use this macro to set all formats in the range. First you n first row need to select the range were your conditional formatting will apply and clear all formatting rules. Next, you need to setup proper color scale conditional formatting in the first row of the range. Now, you should create a name range to reference…

Read more »

Read Registry value into a batch variable

2017/07/06
By
Modified: 2017/06/25
Rue-Sainte-Catherine--2015-

Before I forget, let me share with you a fantastic way to read values from Registry into a batch file variable. Say you need to determine, what is the date format of this machine.  Normally you would read a value from HKEY_CURRENT_USER\Control Panel\International like this: REG QUERY "HKCU\Control Panel\International" /v sShortDate   That command will produce an output similar to this: HKEY_CURRENT_USER\Control Panel\International sShortDate    REG_SZ    M/d/yyyy But you do not need all that.  All you need is the string  “M/d/yyyy” (or “yyyy-MM-dd”).  To get just that string you need to skip to a second line and read third field on the last line.  How you can do that in a batch…

Read more »

Properly Validate TextArea Length (IE vs. Firefox)

2017/06/26
By
Modified: 2017/11/12
TextArea Length - Firefox

Let’s consider this example, where HTML page has a TEXTAREA and an INBOX.  When user types inside TextArea, Inbox should show the length of TextArea string. <script type="text/javascript"> function TTLength(objTT){ var tt= document.getElementById('TXT1'); tt.value = objTT.value.length; } </script> <textarea onKeyDown="TTLength(this);" onKeyUp="TTLength(this);" rows="10"> This Text Area Contains a string With Newline Characters </textarea>  <input type="text" id="TXT1" value="TT Length"/> Let’s see how this page behaves in IE8 and in Firefox 3.6.11. IE8 Firefox As you can see that IE and FF return two different values for the length of an identical  string in TextArea and that could be a serious problem, if you are trying to validate the string length before updating the…

Read more »