The evolution of the modern computer is a fascinating tale, and one that spans several centuries. The term computer used to refer to a person who worked out calculations or computations. This term was coined in 1613 and did not change its meaning from “guy who knows math really well” to “that mechanical marvel that [...]
Archive | Microsoft Windows RSS feed for this section
Command Prompt – Windows Batch Script for Moving Files From One Drive to Another
rem #first establish drive maps
net use x: \\pc1\sharename\folder1
net use y: \\pc2\sharename\folder2
#=============================================
# Use only if you want to clear the destination folder first!
#=============================================
#rem #now you delete the contents
#y:
#delete *.* /y
#=============================================
rem #now you copy the contents of folder1 to folder2 [/s is for subfolders if they exist]
xcopy x:\*.* /s
exit
How to Use Aero Flip 3D and Alt-Tab in Windows 7
Aero Flip 3D was first introduced in Vista. With Aero Flip 3D, you can quickly preview all of your open windows (for example, open files, folders, documents and programs) without accessing the taskbar. It displays your open windows in a visually pleasing stack. To use Flip 3D, click and hold the Windows button together with [...]
Remove All Hyperlinks in Microsoft Word or Excel
Word 1. CTRL+A and then CTRL+SHIFT+F9 2. Credit to http://www.tech-recipes.com/rx/1323/remove-all-hyperlinks-in-word-or-excel/ Go to “Insert” > “Module” and in the pop-up window copy: Sub RemoveHyperlinks() Dim oField As Field For Each oField In ActiveDocument.Fields If oField.Type = wdFieldHyperlink Then oField.Unlink End If Next Set oField = Nothing End Sub Then click “File” > Close and return to [...]
Excel: My Spreadsheet Has a Font?
By default, Microsoft Office Excel 2007 uses the Body Font font in font size 11 (which is displayed as the Calibri font in font size 11 when you type data in a worksheet, header or footer, or text box) but you can change the default font and font size for all new workbooks that you create.
- Click the Microsoft Office Button , and then click Excel Options.
- In the Popular category, under When creating new workbooks, do the following:
- In the Use this font box, click the font that you want to use.
- In the Font Size box, enter the font size that you want to use.
NOTE: To begin using the new default font and font size, you must restart Excel. The new default font and font size are used only in new workbooks that you create after you restart Excel; existing workbooks are not affected. To use the new default font, you can move worksheets from an existing workbook to a new workbook. For more information, see Move or copy a worksheet.
Need a YouTube Desktop Uploader for Windows? Try This!
Having in some instances very large video files to upload to YouTube, I was looking for a desktop tool to upload YouTube videos. Google Video once had a nice, simple tool, as did YouTube once a very long time ago. Since then those tools were deprecated and we were forced to upload large videos through [...]
Microsoft Outlook Freezes and or Crashes When Opening Attachments
Let’s say you’re running Outlook 2007, are connected to a web server via POP, and it freezes/crashes when opening attachments. A solution to that problem would be to locate the “scanpst” utility, usually found here: Outlook 2010: C:\Program Files\Microsoft Office\Office14\scanpst.exe Outlook 2007: C:\Program Files\Microsoft Office\Office12\scanpst.exe Outlook 2003: C:\Program Files\Common Files\System\MSMAPI\<locale ID>\scanpst.exe Outlook 2002/XP: C:\Program Files\Common [...]
Removing All Hyperlinks in Excel
Removing a bunch of hyperlinks can be tedious. Imagine the time you have to spend right-clicking on each of those links and selecting ‘remove hyperlink’ on the context menu. Of course it would just take two clicks, but what if you are to remove a hundred of them or perhaps 1000 hyperlinks? I’m sure that [...]
Excel Macro – Get and Extract Hyperlink URL Address From Link
This has personally worked like a charm for me. Try this user-defined function: =ShowAddress(A1) Where A1 is the cell with the hyperlink in it. Here is the Macro function code: Public Function ShowAddress(rng As Range) As String If rng.Cells.Count > 1 Then ShowAddress = CVErr(xlErrValue) Else ShowAddress = rng.Hyperlinks.Item(1).Address End If End Function Note: With [...]
How to Create a Shortcut or Hotkey to Clear the Clipboard in Windows
Have you ever copied something to the clipboard that you don’t want to leave there in case somebody else is going to use your computer? Sure, you can copy something else to the clipboard real quick, but can’t you just make a shortcut or hotkey to clear it? And of course you can, with [...]
Reality 101 Rantings
Some universities and colleges will hire someone in the working world that “made it” to give a lecture in the “real world.” From my personal experience, I didn’t find those too helpful from the ones I attended.
Ever since Groupon came out with it's Daily Deal site and showed remarkable success, many others wanted to run their own daily deal clone.
This e-Book discusses the opportunities and pitfalls of running your own Daily Deal business.
This e-Book discusses the opportunities and pitfalls of running your own Daily Deal business.
