Rfcolon428
New Member
- Joined
- Feb 1, 2019
- Messages
- 8
I'm trying to open a file with a date in it. I get a runtime error 1004. It can't find the file name with the date of 2/8/2019. I want the date to be in the m-dd-yy format, that is included in the name of the file.
Sub inputboxtest()
Dim dateNeeded As Date
dateNeeded = Format(Date, "m-dd-yy")
dateNeeded = inputbox("what prior date do you need?")
'Enter date as m-dd-yy. No zero in front of m.
Workbooks.Open ("C:\Users\rc\Desktop\All PO Report as of " & dateNeeded & ".xlsm")
End Sub
Sub inputboxtest()
Dim dateNeeded As Date
dateNeeded = Format(Date, "m-dd-yy")
dateNeeded = inputbox("what prior date do you need?")
'Enter date as m-dd-yy. No zero in front of m.
Workbooks.Open ("C:\Users\rc\Desktop\All PO Report as of " & dateNeeded & ".xlsm")
End Sub