How to enter actual work done per resource per day via VBA in MS Project?

Hi, experts,

my question concerns using VBA in MS Project for entering actual work for assignments on the project.

I have created a project in MS Project 2003 and now I want to track the project progress. I want to do it on weekly basis by manually entering time spent on each assignment by each individual resource (see screenshot attached). And of course I want to have it done automatically.

We are not using MS Project Server for various reasons. What we have is the resources are reporting their work in separate Excel sheets. From these sheets I am able to collect for each task ID information on how much time has been spent on the task on which day of the year. But I wonder how can I insert this information into MS Project using VBA.

To be more specific on what will be honoured by points in the answer:
I can open and navigate through MPP in VBA, I can open and navigate through XLS(X) in VBA. I don't know how to input into MPP the same information which is usually input in the screen I have attached, but using VBA.

I know there is an Assignment object available with ActualWork property, but what I need to input programatically is "on 25th of August, resource Res 1 has spent 7 hours of actual work on Task 2", "on 26th of August, resource Res 3 has spent 9 hours of actual work on Task 3" (see the screenshot).

I know this can be done by replacing Excels with MS Project Server, but this is not an option for me. I am looking for an information, which objects/methods/properties to use in MS Project VBA  to simulate the manual input I have described above.