Automation of excel invoice entries




    We are curious to know if anyone has successfully automated the entry of excel based invoices and other docs/entries into peoplesoft? This means, instead of manually typing entries into the spreadsheet having the sheets pre-populated with functions to compute dates, etc. Then running the (I presume macro or VB Script) would load all the sheet/entries needed.  Thanks in advance for any assistance!