Excel 2003 macro running on sharepoint needs two enhancements:
The attached template creates a purchase requisition and increments the number. It needs to:
1. set the default directoy in the 'save as' dialog box to 'My Documents'
2. force a template save to the sharepoint directory with the newly created purchase requisition number
Bid on code change and completion date. Must be able to test on sharepoint