MS Word

 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
User Name:
Password:
Remember me



Go Back   Tutorialized ForumsBusiness ApplicationsMS Word

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread Tutorialized Forums Sponsor:
  #1  
Old June 3rd, 2017, 04:46 AM
leruxy leruxy is offline
Registered User
Tutorialized Newbie (0 - 499 posts)
 
Join Date: Jun 2017
Posts: 0 leruxy User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 1 m 48 sec
Reputation Power: 0
Reminder for tasks every day in word 2010

hello,

As I have to do many work everyday ,I will write the tasks for tomorrow every day in a excel file.

And I will open my word file first every day. Can I just make Word pop up a box with the tasks I have wrote for today so that I can check the task before my work. Any ideas?

Reply With Quote
  #2  
Old June 3rd, 2017, 07:01 PM
robert4u robert4u is offline
Registered User
Tutorialized Newbie (0 - 499 posts)
 
Join Date: Jun 2017
Posts: 0 robert4u User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 28 m 36 sec
Reputation Power: 0
Do you mean you want your word file to be always on top?

Reply With Quote
  #3  
Old June 7th, 2017, 03:37 AM
Luesy Luesy is offline
Registered User
Tutorialized Newbie (0 - 499 posts)
 
Join Date: Jun 2017
Posts: 0 Luesy User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 4 m 41 sec
Reputation Power: 0
I guess you need a add-in to display the task every day. I just find a way to use VBA codes to do that in word. You need to arrange all tasks in an Excel File, then run this macro

Code:
Sub SeeTasksForTodayOrTomorrow()
  Dim objExcel As Excel.Application
  Dim objWorkbook As Excel.Workbook
  Dim objWorksheet As Excel.Worksheet
  Dim dtDate As Date, dtNextDate As Date
  Dim strdtDate As String, strRowNumber As String, strdtNextDate As String, strRowNumberTomorrow As String
  Dim objFoundCellToday As Object, objFoundCellTomorrow As Object
  Dim objDoc As Document
  Dim strButtonValue As String

  Set objDoc = ActiveDocument
 
  dtDate = Date
  dtNextDate = Date + 1
  strdtDate = Int(dtDate)
  strdtNextDate = Int(dtNextDate)
 
  Set objExcel = CreateObject("Excel.Application")
  Set objWorkbook = objExcel.Workbooks.Open("C:\Users\Public\Documents\Sample\TaskFile.xlsx")
  Set objWorksheet = objWorkbook.Sheets("Tasks")
 
  objExcel.Visible = False
 
  Set objFoundCellToday = objWorksheet.Cells.Find(What:=strdtDate)

  If objFoundCellToday Is Nothing Then
    MsgBox ("No task today!")
  Else
    strRowNumber = objFoundCellToday.Row
    strButtonValue = MsgBox("Tasks for " & strdtDate & ":" & vbNewLine & objWorksheet.Cells(strRowNumber, 2).Value & vbNewLine & vbNewLine & "Do you want to see tasks for tomorrow?", vbYesNo)
    If strButtonValue = vbNo Then
      Exit Sub
    Else
      Set objFoundCellTomorrow = objWorksheet.Cells.Find(What:=strdtNextDate)
 
      If objFoundCellTomorrow Is Nothing Then
        MsgBox ("No task for " & strdtNextDate & " !")
      Else
        strRowNumberTomorrow = objFoundCellTomorrow.Row 
        MsgBox ("Tasks for " & strdtNextDate & ":" & vbNewLine & objWorksheet.Cells(strRowNumberTomorrow, 2).Value)
      End If
    End If
  End If
End Sub


There are more details in the article below.

https://www.datanumen.com/blogs/2-smart-ways-get-tasks-day-word-via-vba/

Hope it helps

Reply With Quote
Reply

Viewing: Tutorialized ForumsBusiness ApplicationsMS Word > Reminder for tasks every day in word 2010


Developer Shed Advertisers and Affiliates


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 

Powered by: vBulletin Version 3.0.5
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.

© 2003-2017 by Developer Shed. All rights reserved. DS Cluster - Follow our Sitemap