S
seagroaa
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 "C:\Users\Andy\Documents\@Templates\Timetable.xltx"
into a workbook it causes Excel to crash with the message 'Microsoft Excel
has stopped working'
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 "C:\Users\Andy\Documents\@Templates\Timetable.xltx"
into a workbook it causes Excel to crash with the message 'Microsoft Excel
has stopped working'