TIPS COMPUTER

I hope everyone had a great Christmas, Hanukkah or whatever holiday you celebrate. It is a great time to get together with your family and other people who are important to you and to remember the reason why we are all here.I had a wonderful time getting together with my family in Boston for the holidays. The only minor disappointment was we spent a few days in Vermont and there was literally...

Word VBA - extract Revision Author informationIf you want to know the details of track revisions, for example, Author name etc the following code will help you:Sub Get_TrackRevision_Author()Dim oRev As RevisionDim oRange As Range ----------------------------------------------------------- Change the line below to suit your needs -----------------------------------------------------------Set oRange = Selection.Range ----------------------------------------------------------- Coded by Shasur...

Range Names as AbsolutesI decided to talk about Range Names today since my blog of yesterday was on absolute cell references. Whenever you name a cell, Excel treats it as an absolute cell reference. So, lets talk about this a bit and see why it can be extremely useful to give a cell or a range of cells a name.First, you can use range names in formulas. =Sum(expenses) is a lot more explanatory as well...

Lets look at the example below,In column C dates and column D the error happened on the day with possible multiple entries.The requirement is to calculate the number of times error5 occurred after 5/5/2012 and before 5/15/2012. (answer is 5).Lets put the two dates in A1 and A2. The formula will be =SUMPRODUCT((C1:C22>A1)*(C1:C22<A2)*(D1:D22="error5"))If you do not...

One of our clients reported that they could not access a certain web page from another domain as they were getting the Proxy Authentication error even though they had entered the domain name, user name and password correctly for the proxy setting. The code handling proxy is shown below: Code SnippetImports System.ConfigurationImports System.IOImports System.NetImports System.Text Public Class Form1     Dim InstallerSite As String    Dim...

Sort Word Table columns using Word VBA The following function uses Selection.Sort, you can try alternative methods if selection is not possible / permissible Function SortTable()ActiveDocument.Tables(1).Select()Selection.Sort(ExcludeHeader:=True, FieldNumber:="Column 1", SortFieldType _:=wdSortFieldAlphanumeric, SortOrder:=wdSortOrderAscending, FieldNumber2 _:="", SortFieldType2:=wdSortFieldAlphanumeric, SortOrder2:= _wdSortOrderAscending, FieldNumber3:="", SortFieldType3:= _wdSortFieldAlphanumeric,...

New bloggers are often confused about choosing the right platform for blogging. Most of them choose either WordPress or Blogger to start blogging. But after few months or years, depending on your requirements you may think to switch your platform. Both WordPress and Blogger let you move the site easily. And they support each other! You Should Know -All of your posts will be moved with comments...

Declaring the following in a Userform is one possible cause for the error: Declare Function apiFindWindow Lib "User32" Alias "FindWindowA" _ (ByVal lpclassname As Any, ByVal lpCaption As Any) As Long DLL procedures declared in standard modules are public by default and canbe called from anywhere in your application. DLL procedures declared in anyother type of module are private to that module,...

Add Control To PopupMenuUse this function to add the control to the popup menuFunction Add_Control_To_PopupMenu(ByVal sControlName As String, ByVal sMacroName As String)On Error GoTo DisplayErrDim ctlCB As CommandBarDim ctlMenu As CommandBarControlDim ctlCommand As CommandBarControlSet ctlCB = Application.CommandBars("Cell")If ctlCB Is Nothing Then Exit FunctionSet ctlCommand = ctlCB.Controls.AddctlCommand.Caption = sControlNamectlCommand.OnAction = sMacroNameDisplayErr:If Err <>...

How BIG is Excel 2007 and 2010If you have worked on a large set of data from a non-Excel data source, for example, MS ACCESS, there are chances that you would have stored that in multiple sheets.This riducules the data management. Now in Excel 2007 and above you have a big Excel workbook with 16384 columns and 10,48,576 rowsFollowing table gives you how big Excel has grown :)Excel 2003Excel 2007 and aboveMaximum No of Rows65,53610,48,576Maximum No of Columns25616,...

There is no matter, laptop manufactures gives you the guarantee about the battery that how long it works. The battery of laptop always stops working very early at some stage in essential research, just like when you are watching a DVD movie. Follow the few steps to increase the laptop batterys life: Lower the backlighting on your screen. The screen of your Laptop takes up significant amount of power and you do not require its maximum brightness. You should have to check your system and...

How to Convert Decimal to Octal using VBA Sub Get_Hex_n_OCt_Values() For i = 0 To 255 Debug.Print i & vbTab & Hex(i) & vbTab & Oct(i)Next i End Sub VBA Decimal to Hexadecimal Convers...

Pivot tables are small databases that tend to add functionality to your data.Constructing a pivot table is easy and using it is more e...

Prerequisite Able to use/create charts in Excel. Know how to use "ISERROR" formula. Please refer to Microsoft help for Syntax. Possible UsageTo reflect a clean and accurate in formation in charts.For example, refer to the table below.If we plot Reject Percentage Vs Date we will get,First the chart is not accurate as there was no production in certain days and reject rate...

The ranking of a website depends on several factors. It depends on Google Page Rank (known as PR), Alexa Traffic Rank, Complete Rank and so many. And to check the ranking status, there are thousands of extension available for internet browsers.My personal choice for this purpose is Web Rank Toolbar. Today I am gonna show you how to install this toolbar on Firefox and Google Chrome. Follow the steps...

In the past, whenever I have talked about debugging or evaluating a formula, I have always talked about the Evaluate Formula icon found on the Formula ribbonIt is very useful as it allows you to break apart complex formulas step by step. Click Evaluate to examine the value of the reference that is underlined. The result of that evaluation is shown in italics. If the underlined part of the...

Thu, Jan 8 02:10 PMLondon, Jan 8 (ANI): The safest way to stop fraudsters stealing information from old computer hard drives is to "destroy the PC with a hammer", a consumer magazine has said.The computing magazine Which? recovered 22,000 "deleted" files from eight computers purchased on eBay.They then used specialist software to recover files that the original owner had deleted, reports the Daily Express.Sarah Kidner, editor of Which? Computing, warned that the risk of becoming a victim...

For the past couple of weeks, news about Firefox 3 has been spreading like wildfire all over the Web. Users have been desperately trying to figure out when it will be released and more importantly, how much longer theyll have to wait. Several posts have been made on WorldStarts message board about it as well and since it seems like so many of you are invested in the new version of the popular Web browser, I thought Id give you a little update of my own. Check it out!From what I can see,...

...

At $150, Blue Microphones new THX certified Yeti might not be the best investment for something as simple as Skype, but if you are doing podcasts, music recordings, or old-timey variety shows, it might be worth the extra cash.Apparently, the Yeti is the first microphone to earn a THX certified distinction—something Blue Microphone views as a validation of its "incredibly low distortion, high fidelity,...

1)SEEING IS BELIEVINGNo. Enabling Windows Explorer to "show all files" does not show the files in mention. No. DOS does notlist the files after receiving a proper directory listing from root. And yes. Microsoft intentionallydisabled the "Find" utility from searching through one of the folders.Oh, but thats not all.To see for yourself simply do as you would normally do to clear your browsing history. Go to InternetOptions under your Control Panel. Click on the [Clear History] and [Delete...

Thinking of buying a digital camera for your next vacation? Here is a online service that will help you easily view the different sizes of cameras. While many tools exist to compare technical characteristics, Camera Size lets you know the size of each camera.Camera Size is a user-friendly web application that displays the exact dimensions of digital cameras to better compare. Operation is...

For proper operation of the computer is always better to be cautious. But how? Now well see.Rule # 1) Create a restore point often if you have Windows XP.To do this you click on Help and Support from the Start menu.From the page that appears, you must select Restore wizard. From the window that appears you should put a check mark on Create a restore point, go ahead, enter the date of the day when the operation is performed and select CreateAt this point, Windows will restart automatically.But...

TP-LINK TL-WR2543ND 450Mbps Dual-Band Wireless N Gigabit RouterThree advanced spatial streams reach a maximum wireless speed of up to 450MbpsThe less crowded 5GHz band delivers increase wireless stability allowing users to enjoy a high performance wireless experienceVersatile USB port allows users to share files, media and printers* with friends or family to access the stored data locally or through...