I used to know how to do this, but have been away for too long. I have an Excel 2010 macro I am working on that spits out a fixed field file as it's final output. The file is generated daily and is FTP'ed daily to the client's server. The client wants the format to be INSPECTION2013030154726.TXT. I was using the format function with a format, but the date and time are unchanged from system settings:

    todayDate = Format(Now(), yyyymmdd)
    todayTime = Format(Now(), hhmmss)
I am still playing with it, but not remembering how to do it. Any clues?