Office and Browsers

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

Horizontal Line in Excel Header and Footer

2017/12/06
By
Modified: 2017/11/05
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 »


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

2017/12/05
By
Modified: 2017/11/05
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 »

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

2017/12/02
By
Modified: 2017/11/05
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 »

IE10 is not saving passwords and user names

2017/11/28
By
Modified: 2017/11/05
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 »

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 »