Generate Date-Time for Podcast, Vodcast, or RSS Feed from Microsoft Office

Generate Date-Time for Podcast, Vodcast, or RSS Feed from Microsoft Office

The RSS date/time format is a pain to create if you are building the XML for your RSS feed in a text editor. To make things simple, I created a single line of VBA code that would generate a properly formatted RFC 822 date string that can be used in your RSS feed file.

To generate a string for the current date-time, follow these steps:

1. Open any Microsoft Office application.

2. Open the Microsoft Visual Basic development editor (in Word, it is available through the Tools > Macro > Visual Basic Editor menu).

3. You should see the Immediate window at the bottom of the screen. If not, select the View > Immediate Window menu option.

4. Enter the following code into the window (all on a single line) and press the Enter key:

? format(Now(),"ddd, dd mmm yyyy hh:mm:ss") & " GMT"

5. You should see the properly formatted date and time for the present moment appear on the line below. Simply copy the text and paste it into your RSS feed file!

6. If you want to format a particular date/time, you can use code such as:

? format("12/25/06 11:59:59","ddd, dd mmm yyyy hh:mm:ss") & " GMT"

In the XML file for your RSS Feed, Podcast, or Vodcast, you can add a publication date to an item like this (see line):

http://www.cvisual.com/film-techniques/film-interview-jack-sekowski.asp

http://www.cvisual.com/film-techniques/film-interview-jack-sekowski.asp

Interview with screenwriter Jack Sekowski that also includes free download of a produced script "Who's Your Daddy?"

Arts/Movies/Filmmaking

Thu, 01 Jun 2006 09:27:21 GMT