Bits of Tech

Icon

Tips & Tricks from IT Pros

Create Custom Office 2007 Installations

Today Bits of Tech brings you a video tutorial on creating custom Office 2007 installations using the Microsoft Office Customization Tool. This video takes you through the process of creating custom installs step-by-step. It also features a small segment on integrating the Office 2007 Service Pack 2 update into your installation media.

A good friend of mine loaned me his lab machine with Camtasia Studio 6 on it to create this video. Camtasia Studio is a great screencasting package, but it is a bit expensive at $299. After using his computer with the software on it, I will definitely be purchasing a copy for future video tutorials when my finances allow.

I had planned on sharing this video on YouTube, but the 10 minute video length restriction has prevented me from doing so. I will try to edit 3 minutes out of the video to fit it on YouTube, but no promises, because I don’t want to remove too much content.

ZD YouTube FLV Player

Technorati Tags: Microsoft, Office 2007, Windows

Related Posts

Arranging Menu Bar icons in Leopard

Got a few icons in your Menu Bar and you’d like to change the order they’re displayed in? You’re in luck, they’re fairly easy to move around. Just hold your Command key and drag them into the order you prefer.

Want to get rid of an icon? Hold the Command key and drag it off the menu bar. Gone!

This method doesn’t work with the Apple icons, but not with all apps. Some exceptions to this method are Google Notifier, Tweeie, and Adium. To rearrange these, exit the apps and relaunch them in the order you’d like them to appear from right to left. If they are apps in your Startup Items, you can change the order they launch in to reorder them in the menu bar.

Technorati Tags: Apple, Mac OS, Menu Bar

Related Posts

Configure Windows File Sharing for Easy Migration of Data

Long ago, I learned that setting permissions on Shared Folders in Windows is a bad idea. The issue isn’t in restricting access to data, but in the way Windows handles the permissions.

I work in an Active Directory environment, with thousands of accounts in my region alone. We also rely heavily on file servers. When I first set up our file server years ago, I set all of the permissions on the share rather than on the individual files and folders.

Here’s why that’s a bad idea: When you have to move the shared folder to another drive, RAID array, or even server, you have to redo all of the permissions on the share because they don’t get copied with the folder. If you set the permissions on the shared folder and any subfolders/files, when you copy them to a new drive, those NTFS file permissions follow the data to the new location.

Here’s how I configure my file shares now. First, I create the folder I want to share. Then, right click the folder and choose Properties. Click the Sharing tab, select “Share this folder” and give the share a name. Now, click Permissions and check off Full Control, so everyone connecting to the share has full control. Click OK. These steps are illustrated below.

image image

Now, click on Security tab. Here’s where you’ll set the permissions of the actual folder. First, click the Advanced button and uncheck the box labeled “Allow inheritable permissions from the parent to propagate to this object and all child objects. Include these with entries explicitly defined here.” You will be presented with a box asking if you’d like to copy the permissions, remove them, or cancel. Choose copy, then click OK.

I want everyone to be able to access the root of this folder and the files inside it, so I’m going to click on Everyone in the top pane and ensure “Full Control” is checked. Click OK to save your changes. Now open up your shared folder and move any data you want into it. I have two folders in mine, called Subfolder 1 and Subfolder 2.

I want to restrict access to Subfolder 1 to myself and Administrators of the server only only, so I will right click the folder and choose Properties. In the Security tab, select Everyone in the top pane and click remove. You can leave “CREATOR OWNER”, “SYSTEM”, and “Administrators” there. Now, I will add my user account and assign Full Control to myself. See below, but note I have obscured my Active Directory Domain name and the server name.

image

Click OK on the window here and your permissions change will be saved. I will leave Subfolder 2 with Full Control for Everyone. Now, any users that connect to the share that aren’t Administrators of the server will receive an “Access is Denied” message if they attempt to open Subfolder1.

You can also restrict access to the whole share by assigning any permissions you want in the Security tab of the main shared folder, removing the entry for “Everyone”. This way, anyone attempting to connect to the share will be able to “Map a drive” to the share, but will receive an “Access is Denied” message whenever attempting to open it.

Using the methods above, you can safely move the shared folder to any other NTFS formatted volume on the server or even another server without worrying about having to recreate all of your permissions when you’ve moved it. All you have to do to once it’s moved is share the folder again and assign Full Control to Everyone.

Technorati Tags: Permissions, Sharing, Windows

Related Posts

10 Programs I Can’t Live Without

Anyone who uses a computer for work or personal use on a regular basis has a group of preferred programs to use. Some of us have some programs mandated by our employers, and some of us are free to choose what programs—or even computing platforms—we use. I’m lucky enough to be employed by a company that allows employees to choose what programs they use for the most part.

In no particular order, here are the 10 programs/software packages I absolutely cannot live without. I use both Windows Vista and Mac OS X, so you’ll find programs from both platforms in my list. To keep this post short and not take up too much of your time reading it, I won’t go into too much detail as to why each program has made it onto this list. You can rest assured though, I will save that detail for individual posts later.

  1. Microsoft Outlook 2007 (Windows)
    While we use Microsoft Exchange 2007 as our email server platform at work and Outlook is the best way to go for an Exchange client, I could use any POP3/SMTP or IMAP capable client to check my email. Even given this choice, I stick with Outlook 2007. I prefer Outlook because of the tight integration with Exchange, and because it has everything I need—email, calendar, tasks, and notes—all in one package.
  2. Trillian (4.0 beta) (Windows)
    I have been a Trillian user since their early days, and haven’t bothered with other IM clients. Trillian Pro allows me to use my two primary instant messaging platforms—AIM and Yahoo!—without having two programs running. I’ve been testing 4.0 (Astra) since it entered alpha stage, and now in it’s beta stage. Even in it’s alpha form, Trillian 4 has proven itself a stable and full-featured IM client.
  3. Windows Live Writer 2009 (Windows)
    While I’ve only just started blogging, Windows Live Writer has quickly become my remote publishing client of choice for my WordPress blog. It’s clean interface and ease of use has claimed it spot on my most frequently used programs list.
  4. PuTTY (Windows)
    I use PuTTY to manage all of the Cisco network gear I work with, as well as to log into the Ubuntu server in my office. It’s a very simple, yet powerful SSH client that just works. It has the ability to connect to telnet, SSH, and even Serial clients, and also has the ability to save connection profiles.
  5. Launchy (Windows)
    Launchy is an open-source Windows alternative to the Mac app, Quicksilver. It allows for keyboard launching of programs, opening documents, and even custom triggers. It has a plug-in architecture and there are quite a few useful plug-ins available. I use it in conjunction with the PuTTY plug-in, which allows me to open an SSH session to a host using the keyboard shortcut to invoke Launchy and then type ssh hostname followed by the enter key. I also use a custom trigger that allows me to launch Microsoft Remote Desktop connections via the Launchy interface.
  6. Quicksilver (Mac)
    Quicksilver is a very powerful keyboard launcher for Mac. At the moment, I haven’t delved too deep in setting it up on my machine. I’m only using Quicksilver as a keyboard launcher. I have quite a few applications that I don’t keep in my dock, but use somewhat regularly. It’s handy to be able to easily launch an application by invoking Quicksilver and typing the first few letters of the name. I’m sure it’s capable of much more, but I haven’t really played with it beyond that.
  7. Tweetie (Mac)
    Tweetie is by far my favorite Twitter client out of all of the options available for Mac and PC. It’s slick interface is both great looking and easy to use. Multiple account support is great, and you can choose from a number of URL shortening and picture sharing services. All in all a great looking, feature packed client. The folks at Atebits definitely put a lot of thought into this app.
  8. Firefox (PC & Mac)
    Firefox is my browser of choice, though Internet Explorer 8 is a close second. The extensibility of Firefox is the clincher for me. Having the ability to add functionality to the browser via extensions is an enormous advantage over IE. A few of the extensions I use are GMail Notifier, Greasemonkey, Right-Click-Link, Google Redesigned, Extended Statusbar, Delicious Bookmarks, and PDF Download.
  9. VNC (PC & Mac)
    I use UltraVNC on my PC, and Chicken of the VNC on my Mac. Having the ability to remote control PC’s is an absolute must in my job. We load UltraVNC Server on each of the desktop and notebook PC’s at my company, and we use OSXvnc as the VNC server on the single Mac at each location. Being able to control PC’s or Mac’s from either platform is a big help as well, so I don’t have to have a particular computer with me to provide support.
  10. SplashID iPhone & Desktop (iPhone, PC, Mac)
    Between my personal data from online banking, credit card websites, forums, and other sites, to my business needs for multiple logon accounts, service accounts, and other passwords, SplashID remembers them all. I have a copy of the desktop version on my PC and another on my Mac, and I routinely sync between the three. I got hooked on password managers back when I used CryptMagic on my old BlackBerry, but since moving to the iPhone, I settled on SplashID since it most closely resembled CryptMagic. The fact that it’s available on both Mac & PC was the deal-maker for me, as I routinely use both platforms.

So there you have it, my list of the 10 programs/software packages that I can’t live without. If there’s a piece of software you can’t live without, I’d love to hear about it. Leave a comment and I’ll be sure to check it out.

Technorati Tags: Mac, Outlook, Software, Trillian, Windows

Related Posts

Integrating Service Pack 2 into Office 2007 Installation Media

After Microsoft released Office 2007 Service Pack 2, I wanted to avoid having to install Office 2007 and then perform another installation for SP2. Luckily, Microsoft has made this very easy to do with Office 2007 as compared to earlier versions. No special tools required!

A little information about how this works: Your Office 2007 media has a folder called Updates in it. Any *.msp update files copied into that folder will be installed during the Office 2007 install, but after the suite is installed. The SP2 “fullfile” installer is just a self-extracting archive containing all the source *.msp files needed for the update. So, by copying these files into the Updates folder, you’re getting an Office 2007 install with SP2 integrated.

To integrate SP2, first you need to copy your install media to a local folder. To do this, create a folder in your C drive called Office 2007. Now, copy everything from the root of your Office 2007 install media to C:\Office 2007. Your Office 2007 folder should look similar to the image below.

image

Now, you need to obtain a copy of the SP2 installer. You can download the service pack from the Microsoft Download Center. Save the installer to the root of your C drive. Once you’ve downloaded the file, integrating the service pack is as simple as running one command from the command line.

Open up the command line, navigate to your C drive, and enter the following command. If you saved your Office 2007 install media and/or SP2 file to a different path, make sure you make the appropriate substitutions. Also, if there are spaces in your path, be sure to enclose the path in quotes, as shown below.

office2007sp2-kb953195-fullfile-en-us.exe /extract:”C:\Office 2007\Updates”

Hit enter, then you’ll be prompted to accept the license agreement. If you agree to the terms, check off Click here to accept the Microsoft Software License Terms, then click Continue.

image

When the files have been extracted, click OK on the window notifying you that the installation is complete. Navigate to C:\Office 2007\Updates. Your folder should look similar to the image below.

image

You’re almost done! All that’s left now is create your install media. If you’re going to be installing from a network point, just copy your Office 2007 folder to the network share you plan to install from. If you plan to install from DVD—the resulting folder will likely be just over 800MB—you’ll need to create a new DVD project in your favorite DVD burning software, then drag the contents of the Office 2007 folder into your DVD project. Burn your disc, and you’re ready to install Office 2007 with SP2 integrated.

If you’ve found this post helpful, please leave a comment, I’d love to hear from you!

Technorati Tags: Microsoft, Office 2007

Related Posts

Archives

Follow Me on Twitter: @bill_clark