MrExcel Publishing
Your One Stop for Excel Tips & Solutions

ActiveWorkbooks.SaveAs FileName

Posted by rm on January 15, 2002 7:47 PM


I have used ActiveWorkbooks.SaveAs FileName:=ThisFile
(ThisFile as string and assigning a path and filename value to ThisFile) and it works 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

Posted by Richard Winfield on January 16, 2002 9:02 AM

Have you tried using ActiveSheet SaveAs instead of ActiveWorkbook SaveAs? That may work.