ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Excel crashes when opening a template from VBA 2007 (https://www.excelbanter.com/excel-programming/408975-excel-crashes-when-opening-template-vba-2007-a.html)

seagroaa

Excel crashes when opening a template from VBA 2007
 
I have a template called Timetable.xltx in the folder
C:\Users\Andy\Documents\@Templates. The folder has been added to Excel as a
trusted location 'User Templates'.

When I create a file based on the template from the Excel menu File New
[Select Template] Create it opens OK.

However when I put the following code
Workbooks.Add "

into a workbook it causes Excel to crash with the message 'Microsoft Excel
has stopped working'





All times are GMT +1. The time now is 07:01 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com