Excel Tip: Display Last Saved By Date & User

I found this handy tip to date stamp an MS Excel file's last-saved time (and person). (Yes, files do get time-stamped when saved, but if they are ever sent via email, that date-stamp can get over-written when saved off the server to a local hard drive. This little macro stamps the date right into the worksheet.)

Originally found here:

Here's how it's done: Right-click on worksheet tab, select "View Code". Copy and paste this code into the ThisWorkbook module (It features an Excel document icon on it.) It will automatically run when you save the file.

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)

Sheets('Sheet1').Range('A1').Value = ThisWorkbook.BuiltinDocumentProperties('Last Save Time')

Sheets('Sheet1').Range('A2').Value = ThisWorkbook.BuiltinDocumentProperties('Author')

End Sub

Drop me a comment if you find this useful!

Microsoft charges customers for free services

From WindowsSecrets.com:

"Thousands of customers are paying almost $120 USD per year to Microsoft for an Internet subscription service that includes e-mail, security, and other features.

But Microsoft gives away almost identical services absolutely free in Windows Live and the Windows operating system itself, while neglecting to inform those who pay through the nose.

Free Windows Live eclipses MSN Premium

Microsoft's for-pay service, known as MSN Premium, is a collection of broadband features that must be accessed through a special browser: MSN Explorer. Once downloaded and installed, this browser supports Web surfing, an interface for e-mail and calendar programs, and Microsoft's online encyclopedia, Encarta Premium. Other features, such as an included digital image editor, are accessible by launching a separate application."

[Read More]

Microsoft Virtual Labs

Microsoft Virtual Labs give you great hand-on training by letting you login to a remote computer equipped with the tools you need to try out software before you buy it. It's a great way to get up-to-speed on new technologies. (Something us IT junkies are constantly doing.) Try out Vista, Office 2007, Exchange, SQL Server 2005, Windows Server 2003, SMS 2003 and more at this site. There's also a lot of Developers' Apps to try out! Cool stuff!!

By the way, another great Microsoft resource is the TechNet Library.

"MS I-pod" Marketing Parody by Microsoft

According to iPod Observer, this popular video, found on YouTube and other sites was actually produced by Microsoft marketing as a way of critiquing their own over-abundance of information on their packaging. (This explains the funny spelling of iPod—intentionally avoiding a trademark lawsuit.) The video is hilarious—a true 'net classic!

Outlook XP gets ready for new DST

I just heard about this today! In August of 2005 the United States Congress passed the Energy Policy Act. The Energy Policy Act changes the start and end dates of daylight saving time (DST). When this law goes into effect in 2007, DST will start three weeks earlier (March 11th, 2007) and end one week later (November 4th, 2007) than what had traditionally occurred. All computers will be effected as well as programs which deal with calendar information. For a link to update Windows XP, click here. This is Microsoft Knowledge Base issue KB928388. MS Outlook 2003, 2002 and 2000 will also be affected. The Outlook Time Zone Data Update Tool will take care of these versions of Outlook. Outlook 2007 already has the time change factored in. There will also patches for MS Exchange. When available, the tool will be available at http://www.microsoft.com/downloads/

For more information about how to prepare for changes in daylight saving time in 2007 for all affected Microsoft products, visit the following Microsoft Web site:

http://www.microsoft.com/DST2007