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 [...]
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
#delete *.* /y
rem #now you copy the contents of folder1 to folder2 [/s is for subfolders if they exist]
xcopy x:\*.* /s
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 [...]
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 [...]
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.
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 [...]
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 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 [...]
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 [...]
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 [...]