Muhammad_Bilal
New Member
- Joined
- Sep 1, 2017
- Messages
- 14
I have an Excel file on my Desktop with name "Results_2017_08_31_05_45.xlsx". I want to open it through VBA. As you can see the name contains;
Text "Result",
Date "2017_08_31" and
Time "05_45" it could be "05_50" or "05_55" and so on.
While opening file from VBA
we can handle Date by
, but as time changes with every other file. So how do I able to open this file with Variable time.
Text "Result",
Date "2017_08_31" and
Time "05_45" it could be "05_50" or "05_55" and so on.
While opening file from VBA
Code:
(Workbooks.Open)
Code:
Now()