smart form
 

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

smart form
 

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


--
MattShoreson
------------------------------------------------------------------------
MattShoreson's Profile: http://www.excelforum.com/member.php...fo&userid=3472
View this thread: http://www.excelforum.com/showthread...hreadid=495442