In the old days before we had WebFOCUS I was doing many MF downloads that were then manipulated using VBA to create reports. I would really like not to have to rewite all of it in WebFOCUS as it works fine and I don't have a lot of free time to do that. What I would like to do is set up a Report Caster job that will execute my VBA code. I've figured out how to run a Report Caster job from the MF using JCL and it would be very nice if I could automate the final step to producing my reports.

Any thoughts or ideas? Thank you in advance for your help.

Todd Nicholas

Got to ask, how do you execute VBA on the mainframe?

I don't. I'm using MF downloads and then manually executing VBA against them.

I'm executing report caster jobs from the mainframe. If you would like I can show you how I do that?