I have about 200 Word documents in a directory and meta data for those
files in an Excel Worksheet.

I'd like to upload these files into a Windows application.

I need a scripting tool that will connect to an open windows
application,

Fill some controls with meta data from the Excel Worksheet,

Then click a button that results in having the Window application store
the file.

What tool would do this job?


I vaguely recall working on a test product circa 1996 that would allow
you to turn on a recorder and record user activites by recording the
events of the Windows API and created a VB script. Any ideas on what
that product was. I think I got it from Microsoft Subscription. Any
ideas?

Thanks.