Scheduling nVision through AE

For obvious reasons, I cannot possible document the entire AE in this blogpost so I'll just give a quick rundown.

nVision is scheduled through a series of setup pages under this navigation
Main Menu > Reporting Tools > PS/nVision

Behind the curtains, PeopleSoft is inserting data to the following tables

• PSNVSBOOK
• NVS_SCOPE
• NVS_SCOPE_FIELD
• NVS_SCOPE_VALUE
• NVS_REPORT
• PTNVSQRYPROMPTS
• PSNVSBOOKREQUST

Which means, in order to successfully schedule an nVision instance, you just need to

Add "Download All" Button to Report Manager

I have always wondered why PeopleSoft never included a "Download All" button in all their releases for Report Manager.

Of course, messing with delivered objects is generally frowned upon.
But if you really wanted to implement one, here's a sample.

Excel Macro for SaveAs Filename

Haven't posted much about Excel but this one has been the most common request from business users.

This is a macro to override the "Save As" filename.