Closed Thread
Results 1 to 2 of 2

change date format in VBA code it means change output when printing cheque

  1. #1
    Forum Contributor
    Join Date
    03-13-2013
    Location
    india
    MS-Off Ver
    excel 2010
    Posts
    425

    change date format in VBA code it means change output when printing cheque

    There is VBA code in attached file that code is for cheque printing purpose but that code is password protected ,
    to unprotect VBA code i attached one another file which name is VB first open kotak file then open VB file and run
    code of VB,
    in that code (file name kotak) which i attached problem is date not printing in proper format i do not need .(dot) in date
    currently date printing like 25.12.19 i want like 25 12 2019 , i attached cheque image please see cheque for what date format
    i expect, which cheque image i attached i want that type of date printing on cheque
    Last edited by AliGW; 12-23-2019 at 06:07 AM.

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,369

    Re: change date format in VBA code it means change output when printing cheque

    You have been told that we cannot help you to adapt proprietary code and user forms from a password protected workbook. This thread is closed. Please do NOT open any further threads on this issue.
    Last edited by AliGW; 12-23-2019 at 06:12 AM.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

Closed Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. VBA code for cheque printing
    By keshavtale in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-22-2019, 07:28 AM
  2. [SOLVED] change date format by vba code
    By hktom in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 12-22-2015, 06:07 AM
  3. Change in the data given to me means I need to change my code
    By chad.portman in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-08-2014, 10:41 AM
  4. Need vba code to change date&time stamp as date format dd-mmm-yy in A:A rng
    By breadwinner in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-03-2014, 06:08 AM
  5. [SOLVED] help on vba code to make list continue column and change date format
    By johnodys in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-09-2013, 12:06 PM
  6. [SOLVED] help on vba code to change the error date format as standard format mm/dd/yyyy
    By johnodys in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-13-2013, 01:10 AM
  7. Change date format into text through vb code.
    By ebin charles in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-20-2011, 02:04 PM

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