Excel crashes when opening a template from VBA 2007

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'
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top