I am very new to vb6.0. I got these questions:
in vba 6.0, how to check if time is between today 6:00 PM and next day 6:00 AM then do something.
in vba 6.0, how to check if time is between today 1:00 AM and 6:00 AM then do something.
in vba 6.0, how to check if a path does not exist, create it.
johans22
0
Newbie Poster
Recommended Answers
Jump to PostI'm not sure about the time questions but the path exists question may be answered by this:-
On Error Goto err_handler
Open "c:\test.txt" For Input As #1
err_handler: Select Case Err.Number Case 53: Msgbox "File Not Found" Case 55: Msgbox "File Already Open" Case 71: Msgbox "Disk …
All 2 Replies
mlesniak
22
Light Poster
I'm not sure about the time questions but the path exists question may be answered by this:-
On Error Goto err_handler
Open "c:\test.txt" For Input As #1
err_handler:
Select Case Err.Number
Case 53: Msgbox "File Not Found"
Case 55: Msgbox "File Already Open"
Case 71: Msgbox "Disk Not Ready"
End Select
Resume Next
mlesniak
22
Light Poster
To find out how to calculate time differences, try the following link:-
http://www.developerfusion.com/code/1739/calculating-date-time-differences/
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.