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.
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.
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 […]
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 […]
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 […]
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 […]
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 […]
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 […]
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 […]
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 […]
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 […]
© 2017 DomainWebCenter.com. All Rights Reserved. | Disclaimer | Contact the Editor