+ Reply to Thread
Results 1 to 2 of 2

"Newbie" Excell Macro to change date to next day in Word

  1. #1
    Registered User
    Join Date
    12-21-2014
    Location
    Tidewater Virginia
    MS-Off Ver
    Office 365
    Posts
    1

    "Newbie" Excell Macro to change date to next day in Word

    Help, Please!

    I have an Office 365 WORD document that lists 4 shifts during the course of day. 3 of those shifts are on the current date and 1 is on the next day.

    How can I imbed an Excel macro into the Word document that will change the date field code to the "Next day" and properly account for changes in Month and Year?

    I need this as soon as possible, please help me!

  2. #2
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,372

    Re: "Newbie" Excell Macro to change date to next day in Word

    Hi don and welcome to the forum,

    I find some help at: http://www.gmayor.com/insert_a_date_...than_today.htm

    I used the code there and chopped it into a module in Word. You need to display the Developer tab in Word Options Advanced first.

    Then run the macro where you want that future data. See the attached. I think this is what you are asking.
    Attached Files Attached Files
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

+ 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] How to USE """"" cells count """"" change font color
    By austin123456 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-09-2013, 06:14 AM
  2. Excell opens jepeg, Word, etc "Excell does not recognize this format"
    By parrish70 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 01-27-2013, 08:23 PM
  3. Change date to word "present" change to red
    By soothing in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-09-2007, 02:38 PM
  4. Replies: 2
    Last Post: 08-02-2006, 06:50 AM
  5. Replies: 1
    Last Post: 05-30-2006, 11:30 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