Results 1 to 4 of 4

Code to show date as hh:mm when saving via macro

Threaded View

Greed Code to show date as hh:mm... 09-15-2011, 02:24 PM
Leith Ross Re: Code to show date as... 09-15-2011, 02:44 PM
Greed Re: Code to show date as... 09-15-2011, 03:00 PM
Leith Ross Re: Code to show date as... 09-15-2011, 03:04 PM
  1. #1
    Forum Contributor
    Join Date
    07-15-2011
    Location
    Whitby, Canada
    MS-Off Ver
    Excel 2010
    Posts
    121

    Code to show date as hh:mm when saving via macro

    Hi all - I have this bit of code in a macro that is part of an 'email then save as' function in my spreadsheet. I want it to show the time with a colon in between the hours, minutes and seconds ie: 08:32:26, but as it is, an error occurs because you are not allwed to use the colon in the macro - any ideas? thanks

    TempFileName = Format(Now, "dddd mmmm dd, yyyy @ hh:mm") & " " & Sourcewb.Name & " " _
    Last edited by Greed; 09-15-2011 at 03:00 PM. Reason: Solved

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1