launching (opening) .xlt as .xls...

Posted by rm on December 27, 2001 5:54 PM

hello...I need to assign the launching of an excel template file ("BLANK.xlt") to a button click event, but have an .xls file open, and not the template itself opening...does anyone know the vba code?

(I have placed a button on a worksheet labeled, "NEW DOCUMENT" which, when pressed, will launch a new blank document based on the excel template I have created.)

thanks in advance...rm

Posted by Tamora on December 28, 2001 4:48 AM

Workbooks.Open Filename:="C:\Blank.xlt", Editable:=False