I have created extensive code to derive reports off a current workbook.

What I want to do now is create a macro in my original workbook that will
open a new workbook, run my report code, and then prompt for a save_as name.

The most important part is really just getting a macro to open a new
workbook. I realize the code for my report generating will need to be
modified to refer to the correct pages.