Afro_Cookie
Board Regular
- Joined
- Mar 17, 2020
- Messages
- 103
- Office Version
- 365
- Platform
- Windows
I want to automate some of our production scheduling for future runs and am trying to create some code to select all rows with a date 1 day after today...or the 'today' based on system date.
I've gotten this far (see below), but I'm not well versed enough in VBA and could use some help. Also, this may be very wrong, so any pointers would be appreciated.
I've gotten this far (see below), but I'm not well versed enough in VBA and could use some help. Also, this may be very wrong, so any pointers would be appreciated.
VBA Code:
Sub gather()
Dim TDate As String
Dim TomDate As Date
TDate = Date
TomDate = DateAdd("d", "1", "Date")
Workbooks.Open "book1.xls"
Sheets("Test").Select
End Sub