+ Reply to Thread
Results 1 to 3 of 3

VBA to save file with arrival date

  1. #1
    Registered User
    Join Date
    12-06-2016
    Location
    Poole
    MS-Off Ver
    MS 365 Subscription, Vers. 2310
    Posts
    84

    VBA to save file with arrival date

    Hello all.

    I have been using this form that has a macro build in when you press the 'envelop' button will save a file on your desktop with a specific name and creates a new email with the following subject : "CPReq " & " " & USERNAME & " " & Format(Now(), "mm-dd-yyyy hh-mm AMPM")

    I am looking for a way to change that date from Now, to arrival data that can be found enclosed in the document. I have attached the doc so you can take a closer look.

    Regards,
    Gabriel
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    08-16-2015
    Location
    Antwerpen, Belgium
    MS-Off Ver
    2007-2016
    Posts
    2,380

    Re: VBA to save file with arrival date

    change this part
    Please Login or Register  to view this content.
    to
    Please Login or Register  to view this content.
    Kind regards
    Leo

  3. #3
    Registered User
    Join Date
    12-06-2016
    Location
    Poole
    MS-Off Ver
    MS 365 Subscription, Vers. 2310
    Posts
    84

    Re: VBA to save file with arrival date

    Cheers mate, works like a charm.

    Thank you.

+ 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: 1
    Last Post: 03-16-2016, 08:19 PM
  2. [SOLVED] Macro to save file - save name from cell containing a date using different date formatting
    By d_max_c in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-15-2014, 12:18 PM
  3. [SOLVED] save open worksheet to file and include date of save
    By shaz0503 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-12-2014, 08:50 AM
  4. Replies: 2
    Last Post: 05-30-2013, 12:45 PM
  5. Need a function to calculate the estimated arrival date
    By DorothyFan1 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-17-2011, 04:14 PM
  6. Replies: 4
    Last Post: 09-10-2009, 08:58 AM
  7. Display latest arrival date
    By Annabelle in forum Excel General
    Replies: 3
    Last Post: 02-21-2006, 09:40 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