+ Reply to Thread
Results 1 to 8 of 8

How insert in cell Last Modify Date

  1. 02-20-2015, 02:02 PM #1
    marreco
    marreco is offline
    Valued Forum Contributor marreco's Avatar
    Join Date
    07-02-2011
    Location
    Brazil
    MS-Off Ver
    Excel 2010
    Posts
    1,862

    How insert in cell Last Modify Date

    I can insert in cel name file (.txt), in cell, but i can't insert last modify date.

    Please Login or Register  to view this content.
    Thank you!!
    "No xadrez nem sempre a menor dist?ncia entre dois pontos ? uma linha reta" G. Kasparov.

    If your problem is solved, please say so clearly, and mark your thread as Solved: Click the Edit button on your first post in the thread, Click Go Advanced, select b from the Prefix dropdown, then click Save Changes. If more than two days have elapsed, the Edit button will not appear -- ask a moderator to mark it.
    Reply With QuoteRegister To Reply
  2. 02-20-2015, 02:15 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,595

    Re: How insert in cell Last Modify Date

    http://stackoverflow.com/questions/5...ile-attributes


    https://msdn.microsoft.com/en-us/lib...(v=vs.85).aspx



    Regards, TMS
    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. 02-20-2015, 02:41 PM #3
    marreco
    marreco is offline
    Valued Forum Contributor marreco's Avatar
    Join Date
    07-02-2011
    Location
    Brazil
    MS-Off Ver
    Excel 2010
    Posts
    1,862

    Re: How insert in cell Last Modify Date

    How i would adapt?
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  4. 02-20-2015, 02:59 PM #4
    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,595

    Re: How insert in cell Last Modify Date

    Sorry, pp examples.

    Please Login or Register  to view this content.

    Regards, TMS
    Reply With QuoteRegister To Reply
  5. 02-20-2015, 06:47 PM #5
    marreco
    marreco is offline
    Valued Forum Contributor marreco's Avatar
    Join Date
    07-02-2011
    Location
    Brazil
    MS-Off Ver
    Excel 2010
    Posts
    1,862

    Re: How insert in cell Last Modify Date

    Sorry, but i'm still no adapting, I'll try to explain.

    I have .txt file and i need get name and las date modify (this .txt file), input name and last date modify, insert in cell in active sheet.

    I test your sugestion, but my level vbva is lower to fix it.

    Thank you.
    Reply With QuoteRegister To Reply
  6. 02-20-2015, 08:09 PM #6
    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,595

    Re: How insert in cell Last Modify Date 

    Please Login or Register  to view this content.

    Regards, TMS
    Reply With QuoteRegister To Reply
  7. 02-20-2015, 08:27 PM #7
    marreco
    marreco is offline
    Valued Forum Contributor marreco's Avatar
    Join Date
    07-02-2011
    Location
    Brazil
    MS-Off Ver
    Excel 2010
    Posts
    1,862

    Re: How insert in cell Last Modify Date

    Very nice, thank you much!!!
    Reply With QuoteRegister To Reply
  8. 02-20-2015, 08:45 PM #8
    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,595

    Re: How insert in cell Last Modify Date

    You're welcome. Thanks for the rep.


    Glad we got there in the end
    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. Excel 2003 formula - modify one cell, another cell track the modify date
    By baby0596cw in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 11-06-2014, 12:55 PM
  2. Modify code to Insert row in a worksheet coded to disallow 'Delete' and 'Insert' methods
    By VMDesai in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-02-2014, 06:31 AM
  3. How to modify macro to insert a colored row with a date function??
    By Jason.eschberger in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-11-2013, 03:40 PM
  4. [SOLVED] Modify Macro to insert/delete rows based on cell value
    By Marvelous in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-05-2013, 10:49 AM
  5. [SOLVED] Confused With modify Insert Row below base on cell value
    By herukuncahyono in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-05-2013, 09:29 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1