Home[ Film Books ][ Film Tips and Techniques ][ Graphic Art and Illustration techniques ][ Office Productivity ][ About Me ]Subscribe to my RSS feed


 


. The Latest...

Join Me for Free Hollywood Event On November 2, I'll be on the panel to discuss "Finding Your Place in Hollywood in an Ever-Changing Industry"

Movie Construction Kit template Outline template for making a movie

Male First Names for Writers Sample list of male character first names

WriteRoom for Microsoft Word Writing tool for Word users

What is Vodcasting? Explanation of vodcasting technology

Faking a Painted Masterpiece Create a faux prop painting

Video Podcasting or Vodcasting Introductory Tutorial

Last Names for Writers Sample list of character last names

Generate Date-Time for Podcast, Vodcast, or RSS Feed

Making a Prop Sword Look Real to the Camera

Screenwriter Jumpstart poster

Character traits for Writers

Documentaries for Art Directors / Production Designers

Interview with screenwriter Jack Sekowski Also includes free download of a produced script

Dan's Top 10 Tips for Short Film Makers

Free Script Templates

Film glossary of common terms

My Living Memory free short script

Production Tips and Techniques

Frame ratio template

Location Scouting template

No-cost teleprompter

Depth of Field spreadsheet






 
 

. Film

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

Code to generate RFC 822 Date-Time format for Podcast, Vodcast, or RSS Feed from Visual Basic/VBA in 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"

Here are the code lines small:

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

? 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 <pubDate> line):

<item>
<title>Interview with screenwriter Jack Sekowski</title>
<link>http://www.cvisual.com/film-techniques/film-interview-jack-sekowski.asp</link>
<guid>http://www.cvisual.com/film-techniques/film-interview-jack-sekowski.asp</guid>
<description>Interview with screenwriter Jack Sekowski that also includes free download of a produced script "Who's Your Daddy?" </description>
<category>Arts/Movies/Filmmaking</category>
<pubDate>Thu, 01 Jun 2006 09:27:21 GMT</pubDate>
</item>