Office applications and Web browsers – Tips and macros that make life easier
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 […]
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 […]
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 copying some text from Internet and pasting it into Excel to extract QTY, Amount and Total. The ultimate goal is […]
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 […]
Description of the problem: On Windows 11 Word icon on a taskbar no longer displays the resent files: Steps to fix:–01– Navigate to this location: %AppData%\Microsoft\Windows\Recent\AutomaticDestinations –02– Delete, move or rename this file: 1b4dd67f29cb1962.automaticDestinations-ms –03– Restart the machine –04– Open and edit any Word document to start building the […]
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. […]
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 […]
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 […]
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 […]
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 […]
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 680 x 3 pixels and […]
© 2010-2025 DomainWebCenter.com. All Rights Reserved. | Disclaimer | Contact the Editor