smart form

[pgc]

please help i need a form that will generate 50 training attendance
sheets based on name, dates, trainer, attendants and course day no
i have the sheets but the standard form in excell just doesnt do it.
1 how do i create a form that opens every time i open this file
2 that saves it to a different folder without changing the original
please help
pgc

[MattShoreson]

ActiveWorkbook.SaveCopyAs "C:\TEMP\XXXX.XLS"