Since there is no simple way to create compound excel reports using excel templates (outside of using HOLD files for each)...I created a seperate excel sheet that uses an auto_open macro which takes the compound report that I generate in exl2k and formats each worksheet.

The problem I am having is that I cannot figure out how to execute this excel file to create the formatted excel file.
I tried using a simple dos command to open the excel file, and I even tried creating a .bat file to open that excel file but neither are working. I know I am using the DOS commands properly because I tried to just copy the excel file to a different location and that works fine.

Suggestions?

Eric

Nevermind I figured it out, I just created a scheduled task for the batch file and then I'm having WebFocus execute that batch file through a DOS command in a .fex.

Eric