Shame it's VB6. However...
You can use the "
NET USER[
^]" command to get a list of user accounts on a domain AND to get information about those accounts.
The information includes when the password is due to expire.
Write a program to call net user first to get the list of users (this means that as new users are added there is no further work for you to do) and then for each to collect the information you need. An example in VB6 of running a program and capturing the output can be found
here[
^]
You can then use the
windows scheduler[
^] to run the program regularly