+ Reply to Thread
Results 1 to 10 of 10

populate current date

  1. #1
    Forum Contributor
    Join Date
    10-02-2012
    Location
    india
    MS-Off Ver
    Excel 2010
    Posts
    165

    populate current date

    Hi,

    In the attached sheet, the macro was able to print system date directly in PDF format but now its not working.
    Can anyone help me so that date should be printed on right corner of header

    Advance thanks
    Attached Files Attached Files

  2. #2
    Forum Contributor HerryMarkowitz's Avatar
    Join Date
    09-10-2012
    Location
    Europe
    MS-Off Ver
    Office 2021 - Win10
    Posts
    1,014

    Re: populate current date

    Hi,
    The file you sent does include macros or you protected it with password ?

  3. #3
    Forum Contributor
    Join Date
    10-02-2012
    Location
    india
    MS-Off Ver
    Excel 2010
    Posts
    165

    Re: populate current date

    Hello Herry. Thanks for looking into the matter.
    Ya, the sheet contain macro in module 1 (print_) which print data.Another one is protected which I don't have any idea.

    Please Login or Register  to view this content.

  4. #4
    Forum Contributor HerryMarkowitz's Avatar
    Join Date
    09-10-2012
    Location
    Europe
    MS-Off Ver
    Office 2021 - Win10
    Posts
    1,014

    Re: populate current date

    Hi,
    I just change this line
    Please Login or Register  to view this content.
    to this line
    Please Login or Register  to view this content.
    then date will appear right corner...

  5. #5
    Forum Contributor HerryMarkowitz's Avatar
    Join Date
    09-10-2012
    Location
    Europe
    MS-Off Ver
    Office 2021 - Win10
    Posts
    1,014

    Re: populate current date

    Find pdf enclosed...
    Attached Files Attached Files

  6. #6
    Forum Contributor
    Join Date
    10-02-2012
    Location
    india
    MS-Off Ver
    Excel 2010
    Posts
    165

    Re: populate current date

    No, its not working. See page number 2 in the attached pdf where few columns are populated.

    I want columns (A to N) to print in single page

  7. #7
    Forum Contributor
    Join Date
    10-02-2012
    Location
    india
    MS-Off Ver
    Excel 2010
    Posts
    165

    Re: populate current date

    Finally resolved.Thanks herry for ur support
    I change header to the next line. It is working fine now.

  8. #8
    Forum Contributor HerryMarkowitz's Avatar
    Join Date
    09-10-2012
    Location
    Europe
    MS-Off Ver
    Office 2021 - Win10
    Posts
    1,014

    Re: populate current date

    Change the following lines, then you will see that everything is okey...
    Please Login or Register  to view this content.
    Last edited by HerryMarkowitz; 12-01-2013 at 06:47 AM.

  9. #9
    Forum Contributor
    Join Date
    10-02-2012
    Location
    india
    MS-Off Ver
    Excel 2010
    Posts
    165

    Re: populate current date

    still same issue is there..I am not able to proceed. Is it working for you.
    If yes, can you please attached your sheet so that I can test in my system

  10. #10
    Forum Contributor HerryMarkowitz's Avatar
    Join Date
    09-10-2012
    Location
    Europe
    MS-Off Ver
    Office 2021 - Win10
    Posts
    1,014

    Re: populate current date

    I think it is ok now...
    Check enclosed file...
    Attached Files Attached Files
    Last edited by HerryMarkowitz; 12-01-2013 at 06:47 AM.
    Sub DontForgetThese()
         If Your thread includes any code Then Please use code tags...
         If Your thread has been solved Then Please mark as solved...
         If Anybody has helped to you Then Please add reputation...
    End Sub

  11. #11
    Forum Contributor
    Join Date
    10-02-2012
    Location
    india
    MS-Off Ver
    Excel 2010
    Posts
    165

    Re: populate current date

    Thanks Herry for your hard work

+ 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] Formula Needed to auto populate current date when text entered into a cell
    By excelteam777 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-15-2013, 09:50 PM
  2. Populate cell with current date and time, then lock cell
    By panny in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-17-2012, 06:13 PM
  3. Populate current date
    By maximpinto in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-18-2009, 05:28 AM
  4. Populate listbox with current date value
    By Khaos176 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-25-2009, 12:27 PM
  5. Populate current date when data changes within a row
    By pbct in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-08-2007, 11:16 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