+ Reply to Thread
Results 1 to 3 of 3

format date and time string as folder name

  1. 07-04-2020, 09:38 PM #1
    snkhan
    snkhan is offline
    Registered User
    Join Date
    03-26-2013
    Location
    Canada
    MS-Off Ver
    ms365
    Posts
    79

    format date and time string as folder name

    hello,

    I am trying to save a .xlsm file name with date in it. this is what I have so far

    Please Login or Register  to view this content.
    how can I add current time hh:mm:ss in this string so the results look like:

    mm_dd_yyyy_hh_mm_ss_Report.xlsm

    thank you in advance
    Last edited by snkhan; 07-04-2020 at 10:09 PM.
    Reply With QuoteRegister To Reply
  2. 07-04-2020, 09:57 PM #2
    TMS
    TMS is offline
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,364

    Re: format date and time string as folder name

    Try

    Please Login or Register  to view this content.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke

    Reply With QuoteRegister To Reply
  3. 07-05-2020, 04:36 AM #3
    TMS
    TMS is offline
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,364

    Re: format date and time string as folder name

    Thanks for the rep.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Help with transforming a string into date / time format
    By Mooklie in forum Excel General
    Replies: 5
    Last Post: 06-26-2020, 12:14 AM
  2. Date & Time Stored as Text- How to convert it to Date & Time format
    By Naren_Kumar in forum Excel General
    Replies: 2
    Last Post: 02-06-2020, 10:04 AM
  3. [SOLVED] Converting Unusable Time / Date Format To Usable Time / Date Format
    By Gtrtim112 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-05-2019, 11:25 AM
  4. [SOLVED] Converting Date & Time (General format) to Date (Date format)
    By supremenuts in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-22-2017, 12:55 PM
  5. Need to create a folder in the format of date
    By safi0102 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-13-2013, 06:54 AM
  6. Need Formula/VBA Code to convert date in String Format to Normal Date format
    By Karthik Sen in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-18-2012, 04:54 AM
  7. [SOLVED] Excel date format convert to string format
    By man in forum Excel General
    Replies: 1
    Last Post: 08-17-2006, 05:05 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1