Recently in Desktop Applications Category

2008 Dec 2
I just got my best Windows XP User Experience and i though i would share it with you. I was working while i got it, and so fat it tops all of my other great Windows XP experiences. Well, we don't see those blue screens anymore, Windows XP is so much stable now compared during the time it was first released. I'm running SP3 and so far it looks good except for the error below.

weird-error-on-MSword.jpg










Well, its actually a MS Word error, but i wonder how i got it. "Word has encountered a problem and cannot exit", i know Word has this background task when trying to close an application but i really find the message stupid.
2008 Nov 17
Excel lets you share a workbook and edit worksheets simultaneously. It also allows multiple people to edit every cell or spreadsheet and track changes at the same time. Collaboration between your team will never be the same plus you will be maintaining just one workbook for the entire team which results to less confusion and an updated version for everyone. Updated data will always be available all the time. You can track changes from everybody across the network using their login names and the date they made the update. Excel also prompts you which version of the edit will be posted or you can set it to always overwrite the old ones.

The workbook however need to be in a network share. it must have a write privilege to all your team members. Using Excel 2007, sharing a workbook is as simple as point and click. Here follow these steps.

  1. Open your workbook.
  2. Navigate to Review on the toolbar
  3. Click on the Share Workbook icon
  4. Place a check on the check box that says Allow more than one user at the same time.
  5. Click on OK
  6. Now, save your workbook on a network share

You can use the double slash [ \\ ] to access your file server like this \\FILESERVER
Delete your local version to remove confusion and open the file from the server

You can also create a shortcut to your desktop so that it may be easier for you to open it.

2008 Oct 15
This option is only available for folders included in your user profile. Folders in your user profile include My Documents and its subfolders, Desktop, Start Menu, Cookies, and Favorites. By making your folders private, all the contents inside it will only be available to you. If you do not make these folders private, they are available to everyone who uses your computer. When you make a folder private, all of its subfolders are private as well. For example, when you make My Documents private, you also make My Music and My Pictures private. When you share a folder, you also share all of its subfolders unless you make them private. You cannot make your folders private if your drive is not formatted as NTFS. 

Ensure that Use simple file sharing option is enabled otherwise the make this folder private wont be available. 

  1. Open My Computer, Start -> My Computer
  2. Navigate to your local drive where your profile is located usually drive C:
  3. Open Documents and Settings
  4. Go to Tools -> Folder Options 
  5. Under View tab, scroll down further at the Advanced settings until you find Use simple file sharing (Recommended option)
  6. Enable the option by placing a check on it. 
  7. Click OK button
  8. On your Documents and Settings folder right click on your username.
  9. Select Sharing and Security at the context menu
  10. On the group Local sharing and security group, place a check on the Make this folder private option. 
  11. Please note that you cant make a folder private until you take ownership of the folder. 
  12. Click OK button

This folder will stay private even if you insert the drive into another computer, at least private by default. Of course, if you are the administrator you can take ownership of the folder and take control of its contents. 
2008 Jan 11

The merge and Center button in Excel only centers the top left text and deletes the rest. What if the two columns of First names and last names are to be merged into the format: Last name, First name it would then become a problem.

Using the Ampersand ( & ) operator, it allows us to merge cells in an excel worksheet. you can create a formula to merge cells in excel or just insert it right away on the cell formula bar.

Problem:
And you wish to merge the two cells at A1 and A2 to the cell at A3

Given:
Cell A1 has the text "Lastname"
Cell A2 has the text "Firstname"

Solution:
* First position your active cell on A3.
* On the formula bar input the following: =A1&A2 [ENTER]

It should display LastnameFirstname on cell A3

To add a space and a comma, use the following:
=A1&", "&A2
it will output: Lastname, Firstname

alternatively you can also use the concatenate function, like this:
=CONCATENATE(A1,", ",A2)

2007 Dec 17
Usually when doing some 'copy' 'and paste' stuff would end with so many duplicates. It would be very tedious in manually editing them. when collecting sites for link exchanges, we will get lots of duplicate domains especially from google and wikipedia which most of the links.

Normally, we use advanced filter but something is wrong with it, its not filtering the character 'a'. I got two of them and the result still has two of them. Here is how i did it with advanced filter.

1. Click On an empty cell column
2. On the menu choose: Data -> Filter -> Advanced Filter
3. In the dialog box, type in the range of cells to filter at the List Range text box. e.g. type in $A$2:$A$1319 for cell A2 to cell A1319
4. On the Copy to text box type in the cell location of the output (filtered list)
5. Click on the Unique records only check box
6. Press OK

With the tool duplicate remover, we could remove repeating domain names in an instant. But if we are just simply collecting words and similar list that we become another story. Usually we collect word or phrases and paste them in an excel worksheet. but the question is how to filter the list and remove the duplicates? well i run unto the same problems and luckily i found a macro on the internet, so it saved me the time in creating one.

1. Open Excel.
2. Alt + F11 to open the Visual Basic Editor (VBE).
3. Insert-Module.
4. Paste the code below.
5. Close the VBE (Alt + Q or the X in the top-right corner).

Excel Macro


Option Explicit Sub DeleteDups() Dim x As Long Dim LastRow As Long LastRow = Range("A65536").End(xlUp).Row For x = LastRow To 1 Step -1 If Application.WorksheetFunction.CountIf(Range("A1:A" & x), Range("A" & x).Text) > 1 Then Range("A" & x).EntireRow.Delete End If Next x End Sub

Test the Code
1. In Column A add any data.
2. Tools-Macro-Macros
3. Select DeleteDups and press Run.

source: remove duplicates
2006 Oct 14

Creating a hyperlink in excel is simple. Notice that after typing any uri in excel the text automatically turned into a hyperlink. You can add any link as you like in excel as long as there is a prepended http:// phrase before the text entered.

Now, what if we are going to add a dynamic URL? It would be best explained by example, so here it goes.

For example: We are asked to check multiple sites for the following internet standards; W3C HTML Validator and WDG HTML Validator.

We have a reference cell A1 have the text https://tildemark.com. We all know the URL for the respective standards as:

W3C - http://validator.w3.org/check?uri=https://tildemark.com
WDG - http://www.htmlhelp.com/cgi-bin/validate.cgi?url=https://tildemark.com&warnings=yes

Now, all we need to create an entry such that each time we change the domain names the entry on each validator also changes.

Do the following on Excel:

Cell A1 - https://tildemark.com

  A B
1 https://tildemark.com       
2    
3    
4    
5    
...    
9 =HYPERLINK
("http://validator.w3.org/check?uri="&A1,"Check W3C HTML Validator")
 
10

=HYPERLINK
("http://www.htmlhelp.com/cgi-bin/validate.cgi?url="&A9&"&warnings=yes",
"Page passed WDG validator")

 

More info at Office Website.

2006 Oct 11

Removing a bunch of hyperlinks can be tedious. imagine the time you have to right-click 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 of them? I'm sure that would scrape out the paint of your right-mouse button. :)

I have some simple techniques you can use in order to remove multiple hyperlinks on a page:

Removing just one hyperlink
1. Right-Click on the cell and select Remove Hyperlink on the context menu.

Removing the cell format
1. Select the cells having hyperlinks. You can use CTRL+LEFT CLICK to randomly select a cell.
2. On the menu click on Edit. Hover your mouse to the option Clear and select Fomats. Please note that the cell is still clickable to remove the hyperlink completely you have to select Clear->All.

Remove hyperlink on selected cells the better way
1. Type in any text or number in a blank cell
2. Right-click and select Copy on the context menu.
3. While pressing CTRL, select each hyperlink you wish to be removed
4. On the Edit menu, select Paste Special.
5. Under Operation, click Multiply and then click OK.

Removing using a macro
Assuming you know excel programming you could create a macro to automatically remove the hyperlinks.
1. Start Visual Basic Editor. Alternatively you can press ALT-F11 to start the editor.
2. Double click the workbook you are using on the Project Explorer.
3. Type the following text:


Sub RemoveHyperlinks()
ActiveSheet.Hyperlinks.Delete
End Sub

4. Save your work.
5. Run your macro by pressing ALT-F8 or using the menu by Tools->Macro->Macros
6. Select the macro you have made, it should have the name 'RemoveHyperlinks'.




2005 Mar 29

Somebody installed a new software to my pc which sets the default program for my .jpg files. the icon were not functioning as usual and displays an error message whenever i try to open a jpg image. thanks a lot to this website i have found which gives the solution to reset the file association back to its default application, the Picture and Fax Viewer of the Windows XP OS.

just download this text and merge or (double click it) to your registry file to fix the association of files.

2005 Mar 16

You can now download your Yahoo emails locally using POP3 to any email client you are using, i use MS Outlook 2003. First we need to install a program called YPOPs configure the program and your client then its done.

We all know that there is no POP3 and SMTP support from Yahoo free mails unlike gmail we can configure our client to download mails from the gmail server and send files using gmail SMTP. With the help of this wonderful program, we can now download all emails from the Yahoo server.

1) Download the latest version here.
2) Install the program.
3) Configure it by clicking on the program icon at the tray
4) Configure your mail clients. Use 127.0.0.1 for your SMTP Server and 127.0.0.1 for your POP3 Server.
5) Download mails.

December 2008: Monthly Archives

  • December 2008 (1)
  • November 2008 (1)
  • October 2008 (1)
  • January 2008 (1)
  • December 2007 (1)
  • October 2006 (2)
  • March 2005 (2)

Category Archives

Pages

Find Me Elsewhere

Syndicate

Today is

About this Archive

This page is a archive of recent entries in the Desktop Applications category.

Servers is the next category.

Find recent content on the main index or look in the archives to find all content.

Recent Activity

Today

  • tildemark saved the link Login | ExpressionEngine
  • tildemark saved the link MDR Microware Sales - Computer Distributor Philippines

Wednesday

  • tildemark , "a very disturbing statistics on facebook http://bit.ly/efnM"
  • tildemark , "gmail offline, will this also mean that my mails will be saved locally whenever i go? even in internet cafes?"
  • tildemark , " maybe its already blocked??"
  • tildemark , "@insic you might find this one interesting as well. http://www.stickmanlabs.com/lightwindow/"
  • tildemark , "exploring the world of expression engine..."
  • tildemark , "Hello Twitterland, Im back from the great sandawa flood."

Tuesday

  • tildemark , "Flood! Enjoyed the experience."

Monday