How to install Add-in in MS Excel 2007

1. Click the ball office logo at the top-left of the program
2. Click button “Excel Option”

3. Select item “Add-Ins”
4. Select “Excel Add-Ins” in Manage list box and click button “Go…”

5. Tick the add-ins that you want and click button “OK”

Advertisements

Convert a Excel workbook to an xml file

This post is a bit off topic for this blog but I’ll post it anyway as a reminder for myself and hopefully to help others who want to do the same. At a client someone had to convert a very simple, plain, flat text excel 2007 workbook to an xml file format.

I have made an example to let you see how to do this. Below you see the workbook that has to be converted to xml.

exc_workbook1

I thought that just saving the file with “save as” to xml format would do it but I thought wrong. I got an error that there were no XML mappings found in the workbook. For Excel 2007 you need a add-in that is called OfficeExcel2003XMLToolsAddin.exe and which can be downloaded here. On the download page you can also read how to install and open the add-in in Excel 2007.

Read more: http://www.information-worker.nl/2010/04/19/howto-convert-a-excel-workbook-to-an-xml-file

Unlocking files that are in use

Sometimes you cannot delete or rename a file that is currently in use. You might receive an access violation error, or simply a message telling you that your action could not be completed because the file is open in another program.

image

You may have already come across the Unlocker freeware tool that lets you “unlock” files that are in use by some application.

Here is another way (let’s call it the ‘techie’ way) to unlock files that are in use. It makes use of the Process Explorer tool from Windows SysInternals.

  • Download the Process Explorer tool. Execute procexp.exe
  • Choose Find Find Handle or DLL option

image

  • Type the name of the file you want to unlock and hit Search.

image

  • The process EXE locking the file and the path to the file are listed. Double click on the result.

image

  • The file handle will be highlighted. Right-click on it and choose Close Handle.

Your file is now unlocked and can now be deleted, moved or renamed.

A little disclaimer here, closing handles might cause data inconsistency, loss and/or other undesirable effects. Make sure you understand what you’re doing before you do it.

Add RunAs to Explorer Context Menu in Vista and Server 2008

As a Domain Admin for a small or large corporation, it’s NEVER a good idea to login as the Domain Admin (or other privileged user) to read email or surf the Internet.  After all, if you pickup a nasty bug/virus, from Outlook or Internet Explorer your logged in credentials will have the ability to spread the virus to every system in the company…  Not a good thing!

 

That’s where the RunAs command (XP and Server 2003) came in handy over the years.  You could login as a non-privileged user but if you needed to do something which required Admin rights, you could hold down Shift and Right Click on the application in Windows Explorer and start the application using your Admin credentials.

 

With the release of Windows Vista and Server 2008, this all changed.  True, you could still use the RunAs.exe from the command line however, if you wanted to do it with Windows Explorer.  Fortunately Mark Russinovich has written a new tool called  which adds the RunAs feature to Windows Explorer.

 

Follow the below Step by Step to get it rolling on your box:

 

 

Add Run As Different User to Windows Explorer Context Menu for Vista and Server 2008

1) After you download ShellRunAs from here, copy it to your WindowsSystem32 folder,

 

2) Open a command line and Runshellrunas /reg

Add Run As Different User to Windows Explorer Context Menu for Vista and Server 2008 :: groovyPost.com

 

3) Click OK to confirm Install completed

Add Run As Different User to Windows Explorer Context Menu for Vista and Server 2008 :: groovyPost.com

 

To test, hold down SHIFT and Right-Click on an application.  You should now see the Run as different user in your context menu.

 

Before:

Add Run As Different User to Windows Explorer Context Menu for Vista and Server 2008 :: groovyPost.com

 

After:

Add Run As Different User to Windows Explorer Context Menu for Vista and Server 2008 :: groovyPost.com

Using Tortoise SVN for Joomla updated

more tutorial for totoise SVN :

=============================================================

Since Joomla is continuously in development, nightly builds of Joomla are available for download. These contain bug fixes and enhancements made since the last stable release of Joomla. However, be warned that some items added or fixed may result in new bugs arising. If you still wish to obtain the latest version in development, download and install Tortoise SVN as follows:

Downloading and installing Tortoise SVN

* Click on each image to enlarge it

  1. Go to http://tortoisesvn.net/downloads where you will be redirected to the http://sourceforge.net website. Select the appropriate installer file for your PC and save the file to your local PCInstalling Tortoise SVN - Download Screen Image
  2. Double-click the saved installer file to start the installation. The Welcome screen appears. Click on NextInstalling Tortoise SVN - Install Screen Image Read more of this post

Changing the Apache Port in XAMPP

How to Change the Port

Edit the httpd.conf file to change the port Apache listens on.

(1) Locate the file httpd.conf. This file should be found in C:\xampp\apache\conf (or whichever directory you installed XAMPP in – mine is on my D-drive because that is where I installed XAMPP).

(2) Open the file using a text editor or programmer’s editor (I use notepad++). DO NOT use a word processor (like Word) to open the file, it will badly mess it up.

(3a) Locate the line that says Listen 80. It is line #47 in the XAMPP 1.7.3 install.

(3b) Change the port number (80) to a different number (for this tutorial, I changed it to 1234).

(3c) Save the file.

(4) Restart the Apache Server to have the change take effect. Do this by clicking on the Stop button on the XAMPP control panel and then clicking on the Start button. (You could also just reboot the computer, but that is overkill).

Using the New Port

When you connect to the Apache Server, you will have to append the port number to the URL. Previously where you typed localhost, you will now have to type localhost:1234 (or whatever your new port number is):

Note: in Microsoft Internet Explorer 8 (IE8), it is necessary to prepend the prefix http:// beforelocalhost: localhost:1234 will not work, it must be http://localhost:1234.

I did not observe this with Firefox 4.0 – entering localhost:1234 worked just fine (the browser was able to resolve the address as http://localhost:1234).

Second note: this is not a bug in IE8 – as a convenience, browsers automatically try to fixup URLs for you. Technically, you ARE required to type http:// before every URL you type in.

Backing up System Databases

System databases contain information about user databases as well as meta-data about SQL Server, SQL Server Agent, jobs, alerts, DTS packages and more. Therefore, it is crucial to have valid backups of the following databases:

  1. Master
  2. MSDB
  3. Model
  4. Distribution (if using replication)

Another system database, tempdb, is rebuilt each time SQL Server is started. Therefore tempdb does not need to be backed up. The Model database serves as a blue-print for creating new user databases. This database should not have any activity associated with it, other than the database administrator adding or removing objects required in all user databases. Therefore, you should typically use the SIMPLE recovery model for the Model database and only perform full backups for it.

Read more of this post