ActiveWorkbooks.SaveAs FileName

Hello,

I have used ActiveWorkbooks.SaveAs FileName:=ThisFile
(ThisFile as string and assigning a path and filename value to ThisFile) and it works fine...as long as the code is in the workbook that is being 'saved as.' But I am trying to have one sheet tell another sheet, "Create a new document from a template, save as, then close" and this line doesn't work...keep getting error code that the activeworkbook is hidden(??)...does someone know how to correct this? thanks...rm