Office and IE

MS Office Applications – Word, Excel and Access – Time tested tips and tricks that make life easier

The most dramatic solution are found by readers on our Office and Applications forum.

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/06/25
Properly Validate TextArea Length (IE vs. 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 »

Count Number of Cell with Errors in Excel

2017/06/17
By
Modified: 2017/06/15

This problem occurs, when you have a column with a formula that sometimes returns an error.  That is very typical for all kind of look-up situations .  Let’s say, you have a column E with formula that returns good values and errors.  You need to count how many errors are in that column. Enter formula =SUM(IF(ISERROR(E2:E10),1)) and press Ctrl+Shift+Enter while still in editing mode. You should see two things.  First, your formula turns into {=SUM(IF(ISERROR(E2:E10),1))} with square brackets around it, and second, you got you a correct cells with errors count.  This is it. If you need to count cell without errors, you can use this formula: =SUM(IF( NOT( ISERROR(E2:E10)),1 ))…

Read more »

IE10 is not saving passwords and user names

2017/04/27
By
Modified: 2017/03/03
IE10 is not saving passwords and user names

I hope this post will help a lot of frustrated users out there. PROBLEM: IE10 was working fine, but at one point it stopped saving user names and passwords for web sites. This most securely-configured browser, so switching was not an option.   Here is my solution.  Please see, if it works for you. SOLUTION: For extra security I’ve checked Delete browsing history on exit (see image 1).  I did it without understanding, what it is I am requesting to delete.  To solve my problem, I had to uncheck Cookies and website data on the very next Delete screen (see image 2).  Now IE10 is preserving user names in passwords for visited…

Read more »

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

2017/04/15
By
Modified: 2017/07/15

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 »

Macros to “Paste as Text” for Word and Excel

2017/04/07
By
Modified: 2017/03/14
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 »

Horizontal Line in Excel Header and Footer

2017/04/05
By
Modified: 2017/03/03
Horizontal-Line-in-Excel

  We would like to add a horizontal line to the header of an Excel file to be repeated on every page. To add a horizontal-line we first need to create an image of a horizontal line in your favorite imaging software. Create a PNG image 660 by 3 pixels and color it in some shade of gray.  Save the image with an appropriate meaningful name.  You will be using this file each time you need to add a line to Excel header of footer. Now, insert this image into Excel header: Note that &[Picture] code should be bellow any other code that you have in the header. Now we have…

Read more »

How to Export Yahoo! Group mebers into Excel – Painfull!

2017/04/04
By
Modified: 2017/03/03
How to Export Yahoo! Group mebers into Excel – Painfull!

This is a poor’s man manual on how to export Yahoo! group members list into Excel. Yahoo! used to have this simple feature right on their page, but it is gone now. Instead you would have to do this painful semi-archaic way of getting the data.   To make it look easy we divived the whole procedure into 3 simple steps: Step1.  Display all your Yahoo! group members in “Display Name” order Step2. Copy into Word and fix data inconsistencies Step 3. Copy into Excel and create a link sheet with a proper list         Step1.  Display all your Yahoo! group members in “Display Name” order That is easy.  You need to…

Read more »

Can’t convert Number into a string in Excel (not all space characters are the same)

2017/03/30
By
Modified: 2017/03/29
All spaces appear the same

Problem started as a simple CAN’T CONVERT NUMBER INTO A STRING in Excel. But solving this problem revealed a deep difference between character Space and character No-Break Space. I was  coping some text from Internet and pasting it into Excel to extract QTY, Amount and Total.  The ultimate goal is to calculate the commissions, but that is not important here.  Below is an example of text that I would normally copy into Excel: JO - 10:14:53 Sold 200s @ $19.19 - Total: $3,837.90 JO - 10:10:53 Sold 300s @ $19.19 - Total: $5,749.90   Problem: I can extract quantity 200 into a separate cell, but I can’t do any arithmetic operation on a resulting number.  All the usual tricks as for example multiplying by 1, or…

Read more »

Office 2010 Encountered an Error During Setup – Many Sulutions

2017/03/26
By
Modified: 2017/03/03
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 »

How to Run Malicious Software Removal Tool?

2017/02/28
By
Modified: 2017/02/21
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 »