+ Reply to Thread
Results 1 to 7 of 7

How to get System date

  1. #1
    Valued Forum Contributor mohan.r1980's Avatar
    Join Date
    09-18-2010
    Location
    Mumbai, India
    MS-Off Ver
    Excel 2010 (windows7)
    Posts
    729

    How to get System date

    Hi Friends,

    i made a macro file for users. Every users PC system date are vary
    so i just want to check the system date and then process next script
    i dont know the syntax or parameter of how to get system date.
    Please suggest

  2. #2
    Forum Contributor
    Join Date
    05-30-2014
    Posts
    112

    Re: How to get System date

    Please Login or Register  to view this content.

  3. #3
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: How to get System date

    Does this help?

    Please Login or Register  to view this content.

  4. #4
    Valued Forum Contributor mohan.r1980's Avatar
    Join Date
    09-18-2010
    Location
    Mumbai, India
    MS-Off Ver
    Excel 2010 (windows7)
    Posts
    729

    Re: How to get System date

    Thanks to reply.
    Sorry friends
    i thing i asked wrong question i want to know format of system date which we set Regional and Language.
    some of the PC's have "DD-MM-YYYY" and some of the PCs have "MM-DD-YYYY".
    Because of this i can't run the macro on each PC.
    If i get the System Date of PC then i will set it in script.

    Please suggest.

  5. #5
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: How to get System date

    Maybe?

    Please Login or Register  to view this content.
    Last edited by JOHN H. DAVIS; 03-02-2015 at 11:42 AM.

  6. #6
    Valued Forum Contributor mohan.r1980's Avatar
    Join Date
    09-18-2010
    Location
    Mumbai, India
    MS-Off Ver
    Excel 2010 (windows7)
    Posts
    729

    Re: How to get System date

    Hi JOHN H. DAVIS,

    I try it but solution not working correctly.

  7. #7
    Registered User
    Join Date
    02-20-2014
    Location
    Germany
    MS-Off Ver
    Excel 2013
    Posts
    36

    Re: How to get System date

    Just add the Format() function to the last code :


    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] VBA Macro to Color Row Text If Date in Cell is greater than system date
    By slick9456 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-24-2014, 06:09 PM
  2. Replies: 5
    Last Post: 10-02-2013, 09:49 AM
  3. Date independent of System date in column of Excel
    By gaursh in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-25-2011, 06:30 AM
  4. using Calendar form to store a date changes my system date/time
    By mslynng in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-16-2009, 02:08 PM
  5. Replies: 8
    Last Post: 08-22-2009, 10:03 AM

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