Running a macro on a template
 

I'm trying to run a macro on a template that is linked to
a database, but everytime i open the spreadsheet the
spreadsheet name changes from receiving rpt to receiving
rpt1. Why is the # 1 popping up? so when my macro runs it
doesn't recognize the workbooks name. By the way this
includes auto_open. Please help, i got to get this up and
running by tomorrow. Thanks