Macro Express at the UF Smathers Libraries

Communication Area for Macro Express Unit Developers

Tuesday, October 11, 2005

> Paying Unit Macros in use

Since roughly January 2005, Paying Unit has been using macros I developed to cut down invoice processing time. While there are 11 different macros, they're all slightly modified versions of the same basic macro. It essentially assigns "chartfield string" information to an active ALEPH invoice record in fields specified by FCLA for this purpose. Then it approves the invoice and closes the ALEPH general invoice.

I've created two macros to accomplish updating the budget workbook and publishing an updated Acquisitions Report on the web. They've been in use since October 7. Both routines rely on importing the same table of data from ALEPH ARROW. The budget workbook is an MS Xcel document, while the Acquisitions Report is updated and published to the web using MS Access. The Acq report can be acessed by going to: http://www.uflib.ufl.edu/acqlic/paying/payreports.htm , then clicking Current Acquisitions Report.


0 Comments:

Post a Comment

<< Home