+ Reply to Thread
Results 1 to 6 of 6

today() in Excel 2010 32 bit vba returns different value than Excel 2016 64bit

  1. #1
    Forum Contributor
    Join Date
    08-22-2009
    Location
    Manitoba
    MS-Off Ver
    Office 2010
    Posts
    494

    today() in Excel 2010 32 bit vba returns different value than Excel 2016 64bit

    I was stumped because the vba would error on the "Exportasfixedformat" to pdf in my work Excel 2016 but it worked fine at home on Excel 2010. Then I discovered in Excel 2010, when it would error on the line which I reference a cell with today(), it displays the date as 09-10-2016, which Excel will except as part of a filename, but Excel 2016 displays it as 09/10/2016 which it does not like as a filename. How do I change this? I tried changing the cell format, but in vba it still displays it with the forward slash. Thanks for any help!
    Please Login or Register  to view this content.
    Sheet1.Range("B2") has the formula "today()".

  2. #2
    Valued Forum Contributor WasWodge's Avatar
    Join Date
    08-02-2010
    Location
    Hampshire,England
    MS-Off Ver
    Office 365 and Office 2010
    Posts
    881

    Re: today() in Excel 2010 32 bit vba returns different value than Excel 2016 64bit

    This is a duplicate question to what you have asked here. Please don't waste peoples time by duplicating questions.
    If my solution worked (or not) please let me know. If your question is answered then please remember to mark it solved

    Computers are like air conditioners. They work fine until you start opening windows. ~Author Unknown

  3. #3
    Forum Contributor
    Join Date
    08-22-2009
    Location
    Manitoba
    MS-Off Ver
    Office 2010
    Posts
    494

    Re: today() in Excel 2010 32 bit vba returns different value than Excel 2016 64bit

    Quote Originally Posted by WasWodge View Post
    This is a duplicate question to what you have asked here. Please don't waste peoples time by duplicating questions.
    Sorry, the other thread appeared dead, nobody was viewing it, plus this was a different question than the OP.

  4. #4
    Valued Forum Contributor WasWodge's Avatar
    Join Date
    08-02-2010
    Location
    Hampshire,England
    MS-Off Ver
    Office 365 and Office 2010
    Posts
    881

    Re: today() in Excel 2010 32 bit vba returns different value than Excel 2016 64bit

    Quote Originally Posted by thecdnmole View Post
    Sorry, the other thread appeared dead, nobody was viewing it,
    I would agree if you hadn't only posted it just over an hour ago.

  5. #5
    Forum Contributor
    Join Date
    08-22-2009
    Location
    Manitoba
    MS-Off Ver
    Office 2010
    Posts
    494

    Re: today() in Excel 2010 32 bit vba returns different value than Excel 2016 64bit

    Is there a way to delete this thread as I did get "The" answer which works on the other thread?

  6. #6
    Valued Forum Contributor WasWodge's Avatar
    Join Date
    08-02-2010
    Location
    Hampshire,England
    MS-Off Ver
    Office 365 and Office 2010
    Posts
    881

    Re: today() in Excel 2010 32 bit vba returns different value than Excel 2016 64bit

    Ask a Moderator to see if they are willing to (they normally prefer not to but might lock it if not).
    Either PM a Moderator or use the Report button.

+ 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. Replies: 2
    Last Post: 05-17-2016, 12:23 PM
  2. Excel 2010 vs. Excel 2016 Slicer
    By mycon73 in forum Excel General
    Replies: 0
    Last Post: 03-18-2016, 12:40 AM
  3. [SOLVED] Calendar Function in Excel 2010 64bit
    By antexity in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 08-14-2015, 02:23 PM
  4. How to read custom props on closed file (64bit Win Server, 64bit Excel)
    By soundneedle in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-14-2015, 01:25 AM
  5. Replies: 0
    Last Post: 12-09-2012, 10:43 AM
  6. Replies: 3
    Last Post: 11-23-2012, 01:57 AM
  7. Automation Addin with Excel 2010 64bit
    By malikirfan in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-13-2011, 09:18 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